| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Won't Open up Userform
Hello, I have created a UserForm for inputing data and I am trying to use simple macro to open from a button on the sheet. I have done thi before so I'm not sure why it isn't working. I am creating a module i the spreadsheet with the following: Sub OpenInputForm() frmTrendScoreCard.Show End Sub When I click on it it says it is missing an object... Then runs th DeBugger and highlights the "frmTrendScoreCard.Show" section. While I have done this before, I'm by no means what I would conside adept. If I need to add more inforfmaiton TYIA, PZa -- PokerZa ----------------------------------------------------------------------- PokerZan's Profile: http://www.excelforum.com/member.php...fo&userid=2348 View this thread: http://www.excelforum.com/showthread.php?threadid=47731 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Won't Open up Userform
Are you 100% sure that your form is called 'frmTrendScoreCard'?
Not 'fmTrendScoreCard' or some other minor variation? Simple but most likely! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Won't Open up Userform
Right-click the error line "frmTrendScoreCard.Show" and select Definition.
If VBA does not take you anywhere then the form name is probably spelled wrong (happens all the time!!!) "PokerZan" wrote: Hello, I have created a UserForm for inputing data and I am trying to use a simple macro to open from a button on the sheet. I have done this before so I'm not sure why it isn't working. I am creating a module in the spreadsheet with the following: Sub OpenInputForm() frmTrendScoreCard.Show End Sub When I click on it it says it is missing an object... Then runs the DeBugger and highlights the "frmTrendScoreCard.Show" section. While I have done this before, I'm by no means what I would consider adept. If I need to add more inforfmaiton TYIA, PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=477310 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Won't Open up Userform
I have double checked the name (even copied and pasted the name) and i is still giving me the error #424 Object Required. I'm baffled.. :confused -- PokerZa ----------------------------------------------------------------------- PokerZan's Profile: http://www.excelforum.com/member.php...fo&userid=2348 View this thread: http://www.excelforum.com/showthread.php?threadid=47731 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Won't Open up Userform
I have double checked the name (even copied and pasted the name) and it is still giving me the error #424 Object Required. I'm baffled...  -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=477310 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you make a userform open automatically when you open excel? | Excel Worksheet Functions | |||
| Load caption box on userform open | Excel Worksheet Functions | |||
| Add a button to a sheet to open a userform | Excel Discussion (Misc queries) | |||
| How do I Open A UserForm in a Worksheet | Excel Programming | |||
| Click on worksheet with UserForm open? | Excel Programming | |||
![PokerZan[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
