[mso] Linking one Calendar to different TextBoxes.
- From: robert.allen-turl@xxxxxxxxxxxx
- To: <mso@xxxxxxxxxxxxx>
- Date: Sat, 4 Nov 2006 19:50:09 +0000
Hope someone can help.
I have a User Form for an Excel spreadsheet that has several 'date' boxes.
I have one 'popup' calendar to input any date as applicable.
I want all the 'date' boxes to be able to call a date from this calendar
but all I can find on the Web requires the calendar to be linked with a
single specific TextBox on Calendar_Click (Me.(SPECIFIC INPUT
BOX).Value=Me.Calendar1.Value ).
Tried declaring a global variable so that it will hold a value after the
procedure that gave it the value has finished, and can pass a value from
one procedure to another. I used the name of the input box (TextBox1) that
first called the calendar and declared it with the following line at the
very top of the form's code window before the first procedure.
Dim TextBox1 As TextBox ( This resulted in a Compile Error message 'Member
already exists in an object module from which this object module
derives').
To pass the name of the originating input box to the variable I added Set
TextBox1 =TextBox2 to the next input box MouseDown sub. (This resulted in
a Compile Error message 'Invalid Use of Property'):
If anyone has an answer I would be extremely grateful.
Look forward to hearing from you
Kind regards
Bob Allen-Turl
79 Calver Crescent
Sapcote
Leics LE9 4JD
Tel: +44 1455 272762
Fax: +44 1455 271478
Mobile: 07818 272762
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
- » [mso] Linking one Calendar to different TextBoxes.
