View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuckles123[_54_] Chuckles123[_54_] is offline
external usenet poster
 
Posts: 1
Default 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