VBA Calender - Add Date to Text Value instead of Activecell

Hi Team,

I have one vba calender the code adds date to Active cell , I need small Modification here.

Instead of Activecell , date should be printed on Forms text box.


So in short - Open forms from main module, Calender to pop up,

user will select date and should get printed on Text boxes on forms, and will save that date in a Variable.


I unable to do it on forms. Below is attached macro file.



Thanks
mg

try this

Hi Paul ,

Thanks for your help, I want calender to open after clicking on click event on forms command button,

Whatever date select , date should be printed on text box.

Steps
Click on Assigned Macro Button( Shapes here)
Forms to display
user will fill form
user will date via clicking Select date command which is on forms.




http://www.vbaexpress.com/forum/imag...AASUVORK5CYII=

How does this differ?

Attachment 28040

Attachment 28041

Hi Paul,

Attached is the Amended file, this way I was looking,


needs to add click event for submit and cancel,
for submit value should printed in a cell value
and for cancel macro shoud exit,


But still there is some issue , date is not getting printed in a cell value.



Thanks
mg

Uncomment this line and see if it works

Code:

---

        g_sDate = CDate(CmdBtnGroup.Tag)    '  <<<<<<<<<<<<<<<<<<<<<<<<<<

---