Hello ,
In an excel I have a column with a popup calendar, how can i appy it to another two columns so that it will appear when i click on it.
THx.
Hello ,
In an excel I have a column with a popup calendar, how can i appy it to another two columns so that it will appear when i click on it.
THx.
hi,
try this
Please Login or Register to view this content.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Dear Jonn,
Thamks for your help an it was very helpful. However, i found the popup calendar shown up no matter i clicked on everycell in the worksheet...can u help to figure out the probem?besides, if i want to apply the calendar in alternate colume i have tried:
"If Not Target.Column = 2 And 4 And 6 Then Exit Sub
frmCalendar.Show_Cal
Calendar.xlsmDear Jonn,
Thamks for your help an it was very helpful. However, i found the popup calendar shown up no matter i clicked on everycell in the worksheet...can u help to figure out the probem?besides, if i want to apply the calendar in alternate colume i have tried:
"If Not Target.Column = 2 And 4 And 6 Then Exit Sub
frmCalendar.Show_Cal
But it seems not working...only the second column with the calendarshownup...
Last edited by kachuen2006; 10-21-2012 at 06:00 AM.
hi, I am sorry..try this and see if it works for you!
Please Login or Register to view this content.
Last edited by john55; 10-21-2012 at 06:16 AM.
dear john,
thanks for your promptly reply,it works pefectly..
glad it works for you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks