| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a form visible
I have a spreadsheet that has several buttons on it. I want to move
the buttons to a form and have a single button on the spreadsheet. I have created the form and cant figure out how to make it visible when i click on the button on the spreadsheet. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making a form visible
flynt,
Is the form you've created a Userform (created in the Visual Basic for Applications environment), or a worksheet form (you put your buttons on another worksheet? Are you OK with putting macros in your workbook? -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- wrote in message oups.com... I have a spreadsheet that has several buttons on it. I want to move the buttons to a form and have a single button on the spreadsheet. I have created the form and cant figure out how to make it visible when i click on the button on the spreadsheet. Any help would be appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making a form visible
The form that i have created is a Userform. And, yes, I am okay with
putting a macro in the workbook. I have several already. On Mar 8, 11:31 am, "Earl Kiosterud" wrote: flynt, Is the form you've created a Userform (created in the Visual Basic for Applications environment), or a worksheet form (you put your buttons on another worksheet? Are you OK with putting macros in your workbook? -- Earl Kiosterudwww.smokeylake.com wrote in message oups.com... I have a spreadsheet that has several buttons on it. I want to move the buttons to a form and have a single button on the spreadsheet. I have created the form and cant figure out how to make it visible when i click on the button on the spreadsheet. Any help would be appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making a form visible
Flynt,
If the name of your userform is UserForm1 (default), in your macro, show the form with UserForm1.Show. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- wrote in message ups.com... The form that i have created is a Userform. And, yes, I am okay with putting a macro in the workbook. I have several already. On Mar 8, 11:31 am, "Earl Kiosterud" wrote: flynt, Is the form you've created a Userform (created in the Visual Basic for Applications environment), or a worksheet form (you put your buttons on another worksheet? Are you OK with putting macros in your workbook? -- Earl Kiosterudwww.smokeylake.com wrote in message oups.com... I have a spreadsheet that has several buttons on it. I want to move the buttons to a form and have a single button on the spreadsheet. I have created the form and cant figure out how to make it visible when i click on the button on the spreadsheet. Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making a sum of a eq. with a var running form 0-infinity. | Excel Discussion (Misc queries) | |||
| HELP! Making A Form | Excel Worksheet Functions | |||
| making only specified columns visible | Excel Discussion (Misc queries) | |||
| Making form using Excell Help ASAP! | Excel Discussion (Misc queries) | |||
| Making a new form | Excel Discussion (Misc queries) | |||
Hybrid Mode
