LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 29
Default Maximum Value for Spinner

Hi there,
I have discovered that there seems to be an upper limit for spin buttons. I
am trying to create one that will allow the user to enter anything between
$5,000 and $1,000,000 but the format control section is only allowing a
maximum value of 30,000. Any idea on how I can get around this?
I am using Excel 2007 and form controls, not Activex.
Thanks in advance.
 
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
Return Maximum from Column directly above Maximum in Row Code Numpty Charts and Charting in Excel 2 November 19th 08 07:29 AM
Maximum number in Form Spinner Control ? Darrell Burnett Excel Worksheet Functions 3 March 5th 08 12:49 AM
Autofilter/Spinner GILBERT Excel Discussion (Misc queries) 0 September 7th 06 09:37 PM
Can you hide a spinner??? shnim1 Excel Discussion (Misc queries) 1 March 23rd 06 08:49 PM
Spinner Maureen Excel Discussion (Misc queries) 2 May 23rd 05 02:07 PM


All times are GMT +1. The time now is 12:05 AM.

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"