Hi all.
Firstly please pardon me for my lack of experience with VBA. I am trying to place a minimum and a maximum limit on a spin button (which is on a Userform with a textbox), with the Minimum limit being 0% and Maximum being 100%.
The Spinner controls a named range cell (called percentage_input) and the textbox on my userform is linked to this named range cell.
Please find attached an example workbook to show you the layout.
Do i need to put the limit on the actual worksheet cell? or do i need to write some code on the spinner up/down event (e.g. spinButton1.Min = 0) or something like this?
Many thanks in advance.
Bookmarks