Thread: Convert Text to Num from ComboBox.Addme to Excel
View Single Post
 
Old 10-26-2017, 04:25 PM
CAI TY CAI TY is offline Windows 10 Office 2016
Novice
  
Join Date: Oct 2017
Posts: 1
CAI TY is on a distinguished road
Unhappy Convert Text to Num from ComboBox.Addme to Excel
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.
Reply With Quote