LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
InputBox vs. UserForm for Numerical Data Input Chuckles123[_52_] Excel Programming 1 November 13th 04 07:01 AM
InputBox vs. UserForm for Numerical Data Input Chuckles123[_53_] Excel Programming 0 November 12th 04 04:40 PM
InputBox vs. UserForm for Numerical Data Input Chuckles123[_51_] Excel Programming 3 November 12th 04 08:37 AM
Numerical Input via an inputbox method Tom Ogilvy Excel Programming 0 August 16th 04 07:33 PM
Numerical Input via an inputbox method Bob Phillips[_6_] Excel Programming 0 August 16th 04 07:30 PM


All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"