Trying to put a counter into a form

Diving_Dan

Board Regular
Joined
Oct 20, 2019
Messages
126
Hi all,

I'm trying to create a form to pop up when I click on a specific cell which i'm able to count within. I can code for the form to pop up when i click on a certain cell but it is what to do within the form and coding that.

I would like there to be a box with numbers in. Next to that i would like there to be an up/down arrow button and when you click either up/down the number in the text box increases/decreases.

I hope this makes sense.

Thanks in advance

Dan
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

KlaasE

New Member
Joined
Nov 4, 2019
Messages
35
Hey there,
what you're looking for is probably this:
VBA Code:
Private Sub SpinButton1_change()
TextBox1.Value = SpinButton1.Value
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,099,876
Messages
5,471,280
Members
406,752
Latest member
hkyplyr26

This Week's Hot Topics

Top