![]() |
InputBox vs. UserForm for Numerical Data Input
I read where it is appropriate to initialize text boxes; so I did using: Private Sub UserForm_Initialize() inptCUT_OFF_LEVEL.Value = "100" End Sub (and then deleting the UserForm_Click procedure) I also blanked out the Value and Text Properties for the text box. Now, the Form never pops up and I get the following error message: Run-time error '91': Object variable or With block variable not set When I click-on 'Debug', the Show Form command line is highlighted i yellow. Chuckles12 -- Chuckles12 ----------------------------------------------------------------------- Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494 View this thread: http://www.excelforum.com/showthread.php?threadid=27744 |
All times are GMT +1. The time now is 08:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com