TechTalk & Personal Computing Guide

India-Forums

   
TechTalk & Personal Computing Guide
TechTalk & Personal Computing Guide

Excel Problem of bulbuli75

bulbuli75 Newbie
bulbuli75
bulbuli75

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
HUMM
HUMM

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: 636

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

Author: cdesai12   Replies: 2   Views: 810

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

Author: HUMM   Replies: 6   Views: 1053

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

2 3 4 5

Author: HUMM   Replies: 39   Views: 2167

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

Forum Quick Jump

Forum Category / Channels
Forums

  • 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