Posted to microsoft.public.excel.programming

cubbybear3 cubbybear3 is offline

external usenet poster

Posts: 40

reset the value of a spin button

Q: How can I reset the value of a spin button with out setting off the
CHANGE event?
I am using Office Pro 2003 and have tried the following with out
success:

Application.EnableEvents = False
spnButton1.Value = VarX
Application.EnableEvents = True

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Spin button	aqualibra	Excel Programming	4	December 11th 09 09:40 PM
Please help - Spin Button	the nomad	Excel Programming	7	June 13th 08 11:24 AM
Reset Spin Button	stewdizzle	Excel Programming	2	January 2nd 07 06:06 PM
spin button	bruce forster	Excel Programming	1	May 7th 04 12:21 AM
Spin Button	Andrew[_14_]	Excel Programming	1	July 18th 03 01:51 AM

All times are GMT +1. The time now is 06:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us