Only show msgbox once

Hi All

I have a calculator built as a userform into one of my workbooks, upon opening the userform (calculator) a msgbox is prompted which reminds the user which textboxs to fill in, and let the others do the calculation, this is handy to have at the beginning, but my issue is that it is always there any time you unload, clear, ok, etc.

All i want the user to do is acknowledge the mesgbox, gain access to the calculator, then clear their figures out each time and start again until the exit the userform.

Once the userform has been closed, then if they click on the command button to open the userfrom the msgbox will show again then

Any ideas?

Dan

Please Login or Register  to view this content.

Hi bodhi808

Thank you i have tried this but it still shows the msgbox every time the userform is cleared and reset, i want it to show only on the initial start up of the userform then not again until the user exits the userform and has to use the command button to get back into it.

Dan

Cheers bodhi808, i will have a look and play around with it, after my first try it keeps coming up with a run error, but may be im missing something, il have a go with the code you have shown above and see what im missing/ putting in the worng place

Thanks

Hey, I figured it out

I took away the msgbox from the userform_initialise

and added it to the commanbutton_click, Where the userform generates from, that way i figured the msgbox would only ever show when the user clicks the command button, rather than clearing, reseting, or re-initialising the userform

Hey presto it works

Althought this VBA stuff is extremly hard sometimes, and fairly difficult to understand at first, some things seem so easy it just takes a little bit of thought

Thanks for your help, i wouldnt of realised if i wasnt playing around with the code you gave me

Dan