Userform Macro need minor adjustments to code (Populate Textbox and Combobox Return Issue)

I have a userform which inputs data based upon a chosen item from a combobox. Combobox3 pulls numerical items from Rows17 and below in columnA of active worksheet. The first problem I am having is that the combobox itself is cutting numerical numbers short. Items go out to the thousandths (ex. 1.001) but in cases where there is a "0" at the end of the decimal it abbreviates it (ex.1.01) is there anyway to fix this? The second issue is I would like to populate "Textbox4" with the columnC content of the item chosen. (Ex. User choses Item 1.001 (found in row118) then Textbox4 would = the value of C18) Below is the current code utilized for this userform.

Please Login or Register  to view this content.

Originally Posted by Tinbendr

Use the format function.

Please Login or Register  to view this content.

Tinbendr,

Thanks worked as desired. Could you help with populating "Textbox4" with the columnC value based upon the columnA value chosen in the combobox?

Originally Posted by Tinbendr

This is how I handle that. .

Tinbendr,

It keeps giving me an error on the commandbutton which generates the userform (not in the userform code itself??). Below is the code within the userform:

Please Login or Register  to view this content.

Originally Posted by Tinbendr

Where is the error?

If Range("A" & Rows.Count).End(xlUp).Row) is less than 18, it will generate an error.

You should test the lastrow to make sure it > 18.

You should also test Me.ComboBox3.Listindex to make sure a drop value is selected.

You should also fully qualify the lastrow sheet reference. It saves headaches down the road. Especially if you are referencing multiple sheets.

You can use Activesheet, but that is volatile.

Please Login or Register  to view this content.

Tinbendr,

The problem I have with declaring the sheet name is that it changes names multiple times throughout the formation of the worksheet. This being said you would have to go in each time and adjust the code. That is why I chose to use activesheet.