Button in a field?

[Mitsu]

Hi All,

I have a button with a macro assigned to it so that when it is pressed it will add the date to a field. That part is working.....

but it places the date in the selected field even if it is different than the one with the button in it. What I want to do is have the date appear in the field that has the button that was pressed, even if another cell was already selected ahead of time. that is my Quest!


Thanks in advance,

Mitsu

 

[VulcanJedi]

"QUEST"? kinda dramatic!? This is kinda confusing, do have sample code / more details I don't think this sounds like a difficult problem...

 

[kylua]

Determine the name of the field you want the date to go into and:

sub mybutton_onclick()
intendedfield.text = Date
end sub

if the intended field is a label, you'll need intendedfield.caption = date

 

[Mitsu]

Thank you for your help,
I will try that.

Kylua: does that mean that if I have more that one button, I would need seperate macros, Because I have lots of buttons in each sheet that need to do the same thing for their respective "date" field?

Thanks, again
Mitsu

 

[kylua]

To the best of my knowledge, yes.

If you can set up one macro used by every button, it may be possible to transfer focus to the next tabordered field from the button and add the date to that.

But that's just a thought.