Automating a form open and close

**TDurr** · 08-25-2013, 12:07 AM

So, I've just, JUST started with VBA stuff, and I barely know what I'm doing all ready. Just bear with me.

I just want to know two probably really simple things, and if there's anything else I could do to make the entire deal simpler, I'm game. I'm usually a really quick learner

1. I have a form which asks the user what they're trying to upgrade, and based on the radio button they select, a cell's value should change. I've got that all down in the OK button's... thing... but I can't get the message box itself to close once OK is clicked! I currently have this:

Please Login or Register  to view this content.

2. How can I get this form to open automatically every time a specific sheet is opened? The box that should open up is called OSType.

If there's any better way to put this code into the document, tell me because I wanna know too! Thanks everyone!

**codeslizer** · 08-25-2013, 12:34 AM

You could simply use "Unload Me" to unload the form from memory and to open the form while opening the workbook you could use "Workbook_Open" to do the task. Check out the attached file and let me know if this isn't what you were trying to achieve..

**protonLeah** · 08-25-2013, 01:54 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.