Quote:
Originally Posted by Catalin.B
For selecting a value from a list, is better to create a form, with a list field, you can find here lots of examples. If you cannot find one, i will give you tomorrow an example.
|
Hmmmn Ive allready got that with the Pivot Table. Oh well my goal was to have the user type in a number from 1-9 (6 is not always a valid number though) and it restrict them to that. The reason I wanted it as a macro was so the pivot table will refresh each time they click it.