Macros and command buttons

M

Michael

I'm trying to set a cell (D33) to read 8% based on the click of a command button (in cell C33)

I've never used Macro's before and can't figure it out. Any help would be appreciated.
 
B

Bob Phillips

Put this in the macro

Range("E1").value = "8%"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Michael said:
I'm trying to set a cell (D33) to read 8% based on the click of a command button (in cell C33).

I've never used Macro's before and can't figure it out. Any help would be
Click to expand...
appreciated.
 
S

Stromma

Something like:

'CoomandButton
Private Sub CommandButton1_Click()

Range("D33") = Range("C33") * 0.08 & "%"

End Sub

'Worksheet Change
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Range("D33") = Range("C33") * 0.08 & "%"

End Sub

/Roge
 
Top