Excel - adding +8 on a button click

Question

Excel - adding +8 on a button click

[Closed]

Report

jubu - Jan 20, 2010 at 02:51 PM
WutUp - Jan 20, 2010 at 09:19 PM

Hello,
How do write a macro for adding a specific number to different cell on a button click. Each Click adds 8 to cell I30 Within the sheet your in.

I thought it would be something like this but it does not work
Range("I30").Range ("I30.I30") + 8

Excel - adding +8 on a button click
Excel vba assign macro to button programmatically - How-To - Excel
Excel - Adding the current date in cell - How-To - Excel
Excel - A macro to record button - How-To - Excel
Excel calculating 8 processors - How-To - Excel
Excel adding apostrophe before formula - How-To - Excel

1 reply

Ask a question

WutUp · Accepted Answer · 2010-01-20T21:19:32-0500

Answer 1 / 1

WutUp
Jan 20, 2010 at 09:19 PM

Try this.........

Private Sub CommandButton1_Click()

If IsNumeric(Range("I30")) Then

Range("I30") = Range("I30") + 8

Else

MsgBox "You must enter a number in cell I30", vbOKOnly

End If

End Sub

Excel - adding +8 on a button click

1 reply

Your reply

Subscribe To Our Newsletter!