Convert Text to Num from ComboBox.Addme to Excel

CAI TY · #1 10-26-2017, 04:25 PM

I'm new to VBA - So I hope this is understandable.

ComboBox in my UserForm: cboValues:
1
2
3

4
The number is selected in the ComboBox and added to a column in Excel.
The number is returned as "Text" to Excel so my pivot tables will not recognize the value.
I have tried several VBA coding ideas but none have worked.
I can update the Column to number format in Excel -- but when a new record is added, the cell value from cboValue still returns in Text Format.

Does anyone know how to automate/fix this with VBA code? Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Combobox List	VBA-User	Excel Programming	4	01-07-2016 02:46 AM
Using combobox to pass data from an Excel spread sheet to text boxes on userform	Stewie840	Word VBA	14	12-17-2015 10:13 PM
How to convert a text file to an Excel file with the data format automatically?	mradmin	Excel	6	10-16-2013 10:34 AM
Convert lists of text in Word to excel	Grosspsych	Excel	5	02-06-2012 08:03 PM