Gregor,

Just add this line at the end of your commandbutton1 click event code

Me.Hide

The VBIDE is the VB Integrated Development Environment, or the Visual Basic
Editor to you<vbg. It is more than just an editor, as it has other
facilities, such as the object browser, debugging aids, etc., so it lays
claim to being an IDE.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"gregork" wrote in message
...
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