Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code Help
I have a user form that contains a check box. When the check Box Yes
selection is made, a MsgBox appears providing the user some information. Is it possible upon the "OK" being clicked in that message box to take the user to a defined cell? My MsgBox is telling the user they need to enter data in, say cell B1. I would like to have cell B1 be the active cell after the OK is clicked in the MsgBox. Any ideas? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code Help
You bet... The only trick is that your form can not be Modal. Change the
ShowModal property of the form to false (or when you show the form Userform1.Show False). Now you can get off of the form and onto the sheet. msgbox "Some Description", vbOkOnly with sheets("Sheet1") .Select .Range("A1").Select end with The form will still be shown throughout this process... -- HTH... Jim Thomlinson "TimN" wrote: I have a user form that contains a check box. When the check Box Yes selection is made, a MsgBox appears providing the user some information. Is it possible upon the "OK" being clicked in that message box to take the user to a defined cell? My MsgBox is telling the user they need to enter data in, say cell B1. I would like to have cell B1 be the active cell after the OK is clicked in the MsgBox. Any ideas? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code Help
Thanks Jim. That is exactly what I was after!
"Jim Thomlinson" wrote: You bet... The only trick is that your form can not be Modal. Change the ShowModal property of the form to false (or when you show the form Userform1.Show False). Now you can get off of the form and onto the sheet. msgbox "Some Description", vbOkOnly with sheets("Sheet1") .Select .Range("A1").Select end with The form will still be shown throughout this process... -- HTH... Jim Thomlinson "TimN" wrote: I have a user form that contains a check box. When the check Box Yes selection is made, a MsgBox appears providing the user some information. Is it possible upon the "OK" being clicked in that message box to take the user to a defined cell? My MsgBox is telling the user they need to enter data in, say cell B1. I would like to have cell B1 be the active cell after the OK is clicked in the MsgBox. Any ideas? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Create a newworksheet with VBA code and put VBA code in the new worksheet module | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |