ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   InputBox vs. UserForm for Numerical Data Input (https://www.excelbanter.com/excel-programming/316628-inputbox-vs-userform-numerical-data-input.html)

Chuckles123[_54_]

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