2003 Excel form lists and calendars
Hi
I am creating a form to input data into a spreadsheet. There are several things that I want it to do:
1. Have a drop down list to select an item from (I can't figure out how to create the list. I have a validation list in the spreadsheet, but I can't figure out how to get it in the form)
2. Have a calendar pop up in the form to select dates from.
(I have put it in the spreadsheet, but it doesn't carry over to the form)
Perhaps I am starting out wrong and the form is not linked to the spreadsheet. I went into the MVB area and inserted a form and started creating labels and boxes, but I don't know how it would know where to put the data in the spreadsheet.
Solutions to the Problem 2003 Excel form lists and calendars
Download SmartPCFixer for Free Now
Thank-you!
The listboxes working
but I still don't understand the calendar. This is the code I have in the form:
Private Sub Calendar1_Click()
With Calendar1
Range("B2") = DateSerial(.Year, .Month, .Day)
End With
End Sub
A calendar does not pop up-- also I want the dates to populate in a column-- line by line as information is entered so nothing is overridden in the data file.
Please advise
Thank-you!
Ruth
- Go to the Start button.
- In the Search box, type "regedit" (without quotes) and press Enter.
- Look for the following registry key: "HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\ SQMClient\Windows\DisabledSessions".
- On the right window pane, delete the subkey: "Machine Throttling".
- Restart your system.
Recommended Method to Fix the Problem: 2003 Excel form lists and calendars:
How to Fix 2003 Excel form lists and calendars with SmartPCFixer?
1. You can Download SmartPCFixer here. Install it on your computer. When you open it, it will perform a scan.
2. After the scan is done, you can see the errors and problems which need to be repaired.
3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed
Related: 1327 Invalid Drive Z Error Code 80004004 Error Code 137 80072ee7 Fix 3315 Error 26 3213 1726 0X6be Error Code 1393 Acaptuser32 dll Error 3050 Biosinfo dll,Fast Solution to Fix Error 1017 Received Logging On To The Standby Error,Installation Error 1706 Error Fixer,Loopback Failure Error - How to Fix,How to Fix Pro Registry Cleaner Error,How to Fix Win 7 Installation Error Code: 0x800705070 Error Quickly
Read More: How to Fix Problem - 2010 Mail Merge?,Solution to Problem: 15 column scatter chart,Solution to Error: 2013 Excel does not work,Tech Support: 2 separate multilevel lists in the same document,Fast Solution to Problem: 2.15 free of 54 5 GB what can i do,IE 8: Can't Send Page by Email AND Can't Send Link by Email,I can't connect to yahoo.com for online gaming after installing ex9 is there a problem?,c drive says full with 58gb and drive d has 219gb how to fromat drive c for more gb,Automatic Spelling Correction in MS Excel 2007,Attempting to install a financial program and getting error with regsvr32
No comments:
Post a Comment