Trying to put a counter into a form

Diving_Dan

Board Regular
Joined
Oct 20, 2019
Messages
85
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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

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,090,129
Messages
5,412,631
Members
403,435
Latest member
Rickywilson89

This Week's Hot Topics

Top