Thread: Toggle Macro
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Toggle Macro

Hi
see: http://www.mvps.org/dmcritchie/excel/getstarted.htm

maybe something like
sub foo()
with activesheet.range("D33")
if .value="" then
.value = 0.08
else
.value=""
end if
end with
end sub



--
Regards
Frank Kabel
Frankfurt, Germany


Michael wrote:
I'm having trouble learning Macros. I need to toggle a single cell
(d33) between a value of 8% and blank.

ALSO, I'd love a better site for help topic. MS really dropped the
ball on this topic.

Thanks,
Michael
---