View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
filo666 filo666 is offline
external usenet poster
 
Posts: 265
Default Multiple questions

Hi, I have some things I would like to do:

1) I would like to create a userform that if I select a cell then, the cell
address is obtained (there are this kind of textboxs in the graph forms).

2) I made a program and I would like to create a button in the tool bar (I
know how); what I do not know how to do it is that when the button is presed
(and so my macro modal) then the button will change to activated, when the
button is pressed again my program is deactivated and so the button (like
the design button).

3) how to deactivate the predefined date format, I mean, I would like that
if I type 3-2 it remains as 3-2 and not to be changed to 03-02-2008, I'm
simply not intrested in dates; I also sometimes must write 3/4/3 and I would
like to remain like date (not with date format) and I do not like characters
like ' or "", is it possible???


Thnks for your answers.