Userform to be used to input figures

[Alpacino]

Can a userform be used to input figures onto a sheet. Is this possible? I also like to use 3 comboboxes in userform.
E.g
Training module :______
Dept:______
Staff name :______
Date : ______

The last one (date) o would like an input box which enters the figure into a different sheet depending on values entered in comboboxes

E.g
Training module: fire
Dept: warehouse
Staff name bill smith
Date 29/04/11

So on sheet(4) the figure would be put in
Name column bill smith
Training column fire
Date training completed 29/04/11

Can you use vlookup or hlookup??
Anyone help with code for userform???

Thanks in advance
Alan

 

[Akashwani]

Hi Alan,

take a look here....

http://www.contextures.com/xlUserForm01.html

http://www.contextures.com/xlVideos05.html#UserForm01

I hope that helps you out.


Ak