TechTalk & Personal Computing Guide


TechTalk & Personal Computing Guide
TechTalk & Personal Computing Guide

Excel Problem of bulbuli75

bulbuli75 Newbie

Joined: 27 November 2004
Posts: 25

Posted: 17 January 2005 at 1:56am | IP Logged
thanx humm . hey in any episode can u solve my problem ? i was creating a datasheet that wud accept 1 character in 1 cell in some predefined group of cells and convert them into numerical value (not equal to ascii values) and add them up . well i tried in both ways through functions and macros . in funtion part i cannot think of a function to translate the alphabets to numbers (ranging from 1-8 but not in orderly manner )Cry. and when i was with the macro programming there was  different type of problem .
1. i can enter multiple characters in 1 cell , i tried configuring a masked edit control but that simply refuses  to move with cell selection Angry.
2. when i was done with entering values and have entered the next destined cell in order the macro button is inactive . i have to choose a cell way out of that range to make the button work Confused.
3. the value in the last entered cell is always ommitted in the sum Ouch.

HUMM IF-Dazzler

Joined: 06 November 2004
Posts: 2927

Posted: 17 January 2005 at 7:59am | IP Logged
hmmm... i need some time buddy! ...Confused
can't find the solution now! .. wait for sometime... shall help u out soon!Big smileBig smile
  • Page 1 of 1

Go to top

Related Topics

  Topics Author Replies Views Last Post
Problem with IF Private Messenger

Author: smita24   Replies: 3   Views: 671

smita24 3 671 01 February 2005 at 4:34pm by rabeeak2003
Excel's Hidden Tricks - part 1

Author: cdesai12   Replies: 2   Views: 836

cdesai12 2 836 13 January 2005 at 12:00pm by HUMM
Chocolates Problem--Speed Up ur PC!

Author: HUMM   Replies: 6   Views: 1112

HUMM 6 1112 11 December 2004 at 12:29am by kaleidoscope
Mr.Problem Brings Solution!!

2 3 4 5

Author: HUMM   Replies: 39   Views: 2318

HUMM 39 2318 10 December 2004 at 6:35am by kaleidoscope

Forum Quick Jump

Forum Category / Channels

  • Please login to check your Last 10 Topics posted

Disclaimer: All Logos and Pictures of various Channels, Shows, Artistes, Media Houses, Companies, Brands etc. belong to their respective owners, and are used to merely visually identify the Channels, Shows, Companies, Brands, etc. to the viewer. Incase of any issue please contact the webmaster.

Popular Channels :
Star Plus | Zee TV | Sony TV | Colors TV | SAB TV | Life OK

Quick Links :
Top 100 TV Celebrities | Top 100 Bollywood Celebs | About Us | Contact Us | Advertise | Forum Index