SIMPLE comand code VBA

[sara1989]

Hi Guys

Basically I have a user form and have on my user form 1 combo box, 1 text box and 1 label.
The combo box gives a list when its Initialize() of materials (Based on a list in Column A A4:A50 "Materials" worksheet
The text box will be a empty box that the user will add a number to, example 500
The label also populates the current date when the user form also Initialize()

When the command Button is pressed I need this to look up the material selected from the combo box in the A4:A50 list
Then at the Qty entered in the text box to the current figure in column B I also need the Date from the label in column C

The date can be over written each time a Qtys is added.

Can anyone advise.

Thanks

[Bernie Deitrick]

Please Login or Register  to view this content.

[sara1989]

Hi Bernie

Thank you so much, works Perfectly
Using the code if I wanted to subtract the Textbox 1 Qty would I just replace the + in the formula to a -?

Kind regards

[Bernie Deitrick]

Yes - if you want to subtract just change the + to a -