View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darrell Burnett Darrell Burnett is offline
external usenet poster
 
Posts: 2
Default Maximum number in Form Spinner Control ?

Hi everyone,

I am using a Form Spinner Control, and I want the maximum number to be the
(variable) number in a particular cell, but I can't seem to find any way of
setting a maximum number other than actually manually typing a specific
number into the 'Format Control' dialogue box.

I'm hoping and praying that I'm not going to be told I have to write a
macro, as this is a one-off and I don't particularly want to spend hours and
hours learning how to write macros for a one-off :-(

Thank you to anyone who can help