user forms

[bencnu]

I am having trouble figureing out how to use a user form... I made a user for called nortech and i have an ok button called ok and cancel button called cancle. I also have a text box called textbox1. I want what is typed in the text box to be put in a cell (for ex c4) when the ok button is clicked. But when the cancel button is clicked i don't want anything to happen. The problem is i don't even know how to call the userform or anything like that....

 

[Loomah]

Hi
I'm assuming you are still working in the same project as before?

Either way, call the form in the same way your code was triggered before and use these lines (you don't really need both but to keep it pure)

Load nortech
nortech.Show

For the code for your cancel button use

unload nortech
end

Again you may not need both lines but sometimes the forms remain in memory which could eventually lead to problems.
;-)


If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244