Macros and command buttons

[Guest]

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.

 

[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)

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.

 

[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