Hello all,
I'm using Excel 2010 here.
I haven't really used the 'Microsoft Date and Time Picker Control' before, and I'm struggling to figure how to reference the value once selected.
Idea is - a user can select a date from the picker, then I have a formula reference it from another cell.
Any idea's? A VBA solution would also be fine (provided it's not too complex!
Many thanks,
Gregg
If somebody helps you, say thanks, by clicking *
Click Design mode under Developer Tab and now select the Date Picker object and do right click and select Properties and in Linked Cell property provide reference to the sheet/cell address.
Close the Properties Window and De-Select the design mode in Developer Tab and now try to pick the date in the DatePicker object which will input the selected date in the referenced cell.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Holy moly Sixthsense... you've only gone and hit the nail on the head
Much appreciated.
Gregg
You're Welcomeand thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks