Userform - I can only use textbox - I need to use combobox

trunfos · Jun 10th 2016

Hi, i need help,

I have a userform that only uses textbox

i have this code:

Code

Private Sub ListBox1_Click()
Dim say As Long, a As Byte


For a = 0 To 11


Controls("textbox" & a + 1) = ListBox1.column(a)


Next




Sheets("Dados").Range("A:A").Find(ListBox1.Text).Activate
say = ActiveCell.row
Sheets("Dados").Range("A" & say & ":L" & say).Select
TextBox150 = ListBox1.ListIndex + 1
End Sub

Display More

It works fine, but I now need to use the userform combobox, can someone help me, thx very much.

greetings

**KjBox** · Jun 10th 2016

Re: Userform - I can only use textbox - I need to use combobox

Hi, welcome to Ozgrid.

You have posted in the Hire Help forum.

If you want a completed working code and file to be done for you then you have posted in the correct forum, but you must state in the thread title how much you are offering for the solution and pay 10% of that amount to [email protected]

If, however you meant to post in the general help forum then reply to this to say so and I will move the thread to the correct forum.

**royUK** · Jun 10th 2016

Re: Userform - I can only use textbox - I need to use combobox

You might get an answer if you actually state what the combobox is required for.

trunfos · Jun 13th 2016

Re: Userform - I can only use textbox - I need to use combobox

Hello, i make a mistake, can u change to general help forum please, thx

trunfos

**S O** · Jun 13th 2016

Re: Userform - I can only use textbox - I need to use combobox

Thread moved.

Userform - I can only use textbox - I need to use combobox

Participate now!

Share