Hi there. I am creating an employee time sheet which tracks what project a person is on. I have a Combo box that has predefined project criteria (of course).
I would like to do is have, as a last option, "Other - Please Specify" If this option is chosen, then the person will be able to manually write in a custom text pertaining to what custom project they worked on for that day.
Is there an efficient way to do this?
Thanks for your help!
Update:This is what I wrote:
Update 3:Private Sub UserForm_Click()
If ComboBox1.Value = "Other - please specify" Then TextBox1.Visible = True
End Sub
Private Sub UserForm_Initialize()
ComboBox1.List = Array("Choose One", "Administration", "Asset Audit", "Eng", "FFE", "Focus Group", "Holiday", "Meetings (Other)", "Meetings (Project)", "RMT", "SDA Report", "SDO", "Sick", "Tech Serv", "Training", "Vacation", "Other - please specify")
End Sub
Answers & Comments
Verified answer
Add a textbox under it and call it textbox1 for the example. Under properties for this item, set the visible property to false.
then under the combo box change code add this line...
If ComboBox1.Value = "Other - Please Specify" Then TextBox1.Visible = True
This should allow you to add your specified project criteria.
Elizabeth Lily Isla Katherine Leah Violet Madeline Alice Alexandra Claire Eleanor Ruby Emily Maeve Arielle Naya Benjamin Charles Henry Andrew Isaac James Elias Joel Everett Jonas BQ: Autumn Felicity -- 5/10. i like the call Felicity, yet i'm no longer prepared on Autumn. against Felicity, and something of your names to be ordinary (shop for Naya, Hallie, Blaire, Brooklyn and Arielle), it would not have the comparable sense to it because of the fact the others, coming in the time of as well-liked. It has no age to it, and on an identical time because it may sound superb on a splash lady, i'm no longer able to make sure it being on a grown person or an previous woman. Felicity, on the different hand, is gorgeous. it incredibly is have been given a classic sense to it, and is sublime. on the plus facet this mixture does flow nicely. Isaac Joel -- 8/10. i actually like this mixture. the two are stable, handsome biblical names, that flatter one yet another quite nicely. it would age large besides. :) Victoria