LinkBack URL
About LinkBacks
I created a activex ComboBox (under form controls) to show numeric figures.However, the combo box linked cell is showing the numbers as text.
How can I correct this issue?
btw...i run Excel 2007 version.
Thanks in advance.
I created a activex ComboBox (under form controls) to show numeric figures.However, the combo box linked cell is showing the numbers as text.
How can I correct this issue?
btw...i run Excel 2007 version.
Thanks in advance.
can you upload the workbook? have you tried the =value and copy paste speacial > values?
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
The most likely cause would be that your linked cell is formatted as Text. Even if your initial list cells are formatted as text, the linked cell should report the result as a number.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Here are some attachments; the jpeg will indicate the issue at hand.
To ChemistB, I tried to format the linked cell to show numeric value, but every time I change the figure on the combo box, the formatting gets undone. (I wish to show the linked cell result as #" eg:- 48")
Don't use a linked cell - it will always be text. Use code in the combobox to populate the cell instead.
Everyone who confuses correlation and causation ends up dead.
I used a spare cell to link to the combo, H5.
The in B26 I used the formula =H5*1
OK, that would work. But I am still in the issue of the linked cell automatically reformatting to its original state every time I make a choice on the ComboBox.
ummm....ok......how?Originally Posted by romperstomper
Like this.
yeh, that's more or less it. But I can't seem to access your Comboboxes.
Any reason why?
Never mind!!!
I applied your code, and the the thing is working like a charm. Thanks!!! I am sooo not good with code-writing. Recommend any good sites to learn from?
Hi Guys,
I am new to this forum.
I am facing the same problem with Combo boxes. The linked cell is showing the numbers as text. I could not find the code you guys are talking about to solve my problem. Please help.
Thanks.
If you put it into design mode and right click on the combo box> View Code, it'll open the VBA editor. The code is embedded into the sheet module so right click on your sheet tab and "View Code" and paste the code in (modifying it for your cell destination).
I found very helpfull your file.
Thank you,
ShpendG
Re: combobox result coming as text, not numeric
Hi,I created a activex ComboBox (under form controls) to show numeric figures.However, the combo box linked cell is showing the numbers as text.
How can I correct this issue?
btw...i run Excel 2007 version.
Thanks in advance.
Use 'Val' function in the code where you want to display the results.
eg:- activecell.offset(0,3).value = val(cboSalary.value)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks