VBA Userform issue

Hi everyone,

I would like to know the following:

I created a userform to add information into range of data and one of my Combobox is numeric i.e. it is supposed to be percentages.
But in the code I only have :
ComoBox1.ColumnCount=1
ComboBox1.List() = Array("10%","20%")

and it gives me the percentage in a alphanumeric format

how can I change it in the vba code so that it gives me directly numeric


Thank you in advance for your help

Typically, you'd use a hidden column holding the numeric value and hide it:

Please Login or Register  to view this content.

Though in this case, you could parse it like this:

Please Login or Register  to view this content.

Thank you very much for your answer.
But I dont want to have a message to appear, I Need to that once I add some infromation by clickin on the add button i created in the form the information of the percentage is added in a percentage format in the excel sheet and not in a text format

Then remove the MsgBox line and write the output to the sheet rather than a message box

If you don't know how to do that then post your actual code.

Ok thank you here is my code :

Option Explicit
Dim Ws As Worksheet

Private Sub UserForm_Initialize()

Dim J As Long
Dim I As Integer

ComboBox1.ColumnCount=1
ComboBox1.List()=Array("0%","10%","20%", "30%", "40%", "50%", "60%", "70%", "80%", "90%", "100%")

End Sub

That’s not writing anything to a worksheet. So post that, also, please edit your post to include code tags