Command VBA UserForm

[tjw06d]

I have a user form with three things:
Two combo boxes and a command Box

The first combo box just uses a range of different products from the ws.
The second combobox are numbers 0-100 in increments of 5. (values I want to assign)

Lastly my command box is what I want this user form to do, which is:

Find value in first combo box match with string in ws, take number in second command box and offset by 28 columns, and input number in that column. Close userform when finished.

Heres my poor coding so far:

Please Login or Register  to view this content.

Thanks in advance!!

[Norie]

At first glance the code looks fine apart from the looping which isn't needed as you know the names of the controls involved.

Actually I've just noted something else, you are using the value in ComboBox1 for the offset.

Shouldn't you be using the value 20 in the code if you want to offset that no of columns.

Also you seem to be putting a value from the worksheet in TextBox2.

What happened to the second combobox?

[tjw06d]

Please Login or Register  to view this content.

I actually switched it to this, hoping to condense it. Still not updating cells nor exiting userform. :/

[Norie]

Are the values in column A of the worksheet numeric?

If they are then you need to convert the text value of the selected item in the combobox.

You can do that with CLng or Val.

Please Login or Register  to view this content.

[tjw06d]

the first combo box is based off text in a range, the second combo box is based off

Please Login or Register  to view this content.

I'm trying to get the command button to take combobox 1 find in range A:A, offset 28 columns and add value from second combox into 28th column, and exit user form

Please Login or Register  to view this content.

Unfortunately its not updating in workbook nor is it exiting out of userform. I don't get any error messages. I'm at a loss.

[Norie]

The values in the combobox are text, not numbers.

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[tjw06d]

I was creating a mock up for you and it ended up working so I just reqrote the vba in my file and now it works :/ I guess I should be happy and would be if I hadn't spent 4 hours trying to edit this code into oblivion. Thanks anyways!!!