Hi,
I have two questions regarding dropdown lists.
Is it possible to insert a calender into a dropdown list and can I add an "openfield" which allows the user to type in an new opinion, which is not part of the list?
And another question, not related to the topic: Is there a similar forum for Microsoft Access?
Thank you very much for your help in advance!
Regards,
Tim
You can use the Microsoft Date Time Picker Control Version 6.0.
To activate controls on UserForms in your VBA project
- In the Visual Basic Editor, with your UserForm open, right-click on or near a control on the Toolbox.
- Click Additional Controls to display a list of all available ActiveX controls.
- Note The list is dynamically created, and many controls that appear will
have been installed by various applications or downloaded from the
Internet. However not all controls are suited to be placed in the host
containers listed earlier. Doing so can result in unexpected behavior.- Select the desired control from the list. Microsoft Date and Time Picker Control, version 6.0
- Click OK.
- Once the control is activated, an icon for that control is added to the
Toolbox.
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks