Cell in Edit mode in VBA

[prajul89]

Hi All,

Well, I have a macro which when after editing certain cell puts Today's Date as default in Cell B5 and activate that cell for user.


User can change the cell as per his requirement. Now can the cell be in Edit mode for user automatically like when we press F2.

 

[prajul89]

Is send key the only option for this??????????

 

[prajul89]

I guess no Answer = no solution. So I have to go with Send Key

 

[UglyBunny]

I think it might be possible to bring up a message box for user input and enter it into the cell, not exactly what you were looking for but I think it would work.
Sadly I'm not experienced enough to write that.. but maybe someone will read this and know how to!

 

[prajul89]

Thanks for the response.
But I don't want it to be complicated for the user by using a msgbox. Thanks Anyways.