Macro to edit cell creating a formula - Microsoft Community

i macro when activated on current cell (always numbers), put current cell in edit mode, put equal sign @ beginning of number shown, go end of number, add multiply (*) sign wait input complete formula.

***office sub-topic moved microsoft office programming moderator.***

raymond schenck:

try in general/standard module

sub abc()
dim s string
s = activecell.value
s = "=" & s & "*"
sendkeys s
end sub

--

regards,

tom ogilvy

Office / Excel / Microsoft Office Programming / Unknown/other