Userform Vlookup Increment Cell Value

[Allas]

Hi,

I'm new to the forum!

I have a list of transport companies in column E with their consignment/reference numbers in column G.

I have a userform with a combobox, a textbox and a command button.

With the command button, I would like to increment the consignment number to the relative transport company (i.e. combobox.value).

I found how to increment the value of a cell - Range("A1").Value = Range("A1").Value + 1

But how do you 'vlookup' and increment the value of that cell? Any help would be much appreciated

Please Login or Register  to view this content.

[AndyLitch]

You might want to consider using combobox1.listindex instead of Vlookup....... Listindex returns the row number of the selected item and is easily related to a worksheet row and therefore cell..

[Allas]

Sweet, thanks for that! I had to +2 for some reason but I got it working anyways Cheers!

Please Login or Register  to view this content.

[AndyLitch]

The Listindex property starts at 0