Many thanks Tolga I eventually got the code in correctly and everything is
working well. You have saved me many hours....thank you. One small thing I
would like to happen is for the user form to disappear when I click the
enter button . Is this possible?
To answer Bob's question : I'm not really sure what VBIDE is let alone
using it for designing forms. What I have been doing is going to Visual
basic editor insert user form view code at the top of the project
explorer window then I paste the code in.
Do you have a suggestion for another method?

Regards
GregorK


"gregork" wrote in message
...
I am sorry to be posting on this subject again but I have spent hours
mucking around in help files and google searches with no success. The end
result is confirmation that I don't know what the hell I'm doing in VBA so
I'll describe what I'm trying to do and gratefully accept any advice.

I have inserted a user form (userform1)as a VBA object with the following
objects: combobox1, textbox1, CommandButton1 and CommandButton2.
This is what I want the code to do:
-combobox1-range=sheet!3 A3:A200 and destination cell=C3.
-textbox1- destination cell = R3.
-CommandButton1- Enter data and close the userform.
- CommandButton2-Cancel.

Regards
gregork