Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

VBA List Box or radio buttons

Comment:

I have an excel program that tracks job progress for a cabinet shop, and I need to figure out a way to create a user input box with a list of selections that then passes the users selection to a variable. It would be similar to: Job_Status = InputBox(Prompt:="Please Enter Current Job Status.", Title:="Job Status", Default:="") Except that instead of an open field that the user can type into, it needs to be a list of 8 potential options and the user can only select one of the options: I tried this: ListBox1.List = Array("Option 1", "Option 2", "Option 3", "Option 4", "Option 5", "Option 6", "Option 7", "Option 8") But it doesn't work. It would also work fine to have eight radio buttons that they need to select from if that were possible. Any ideas?

rename using parts of fil...

New subfolders under deep...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, How do I assign a value to checkboxes or radio buttons contained in a groupbox control in VB.NET? I would like to use a Select Case statement to assign the values as such: Select Case GroupBox1 Ca...

Summary: Hello guys, I've been working on getting the tab order of radio buttons on my windows form right...but something just seems amiss. I've got a simple windows forms application (VB.Net on the 1.1 fram...

Summary: Hello: I have problem with records in list box here is the code that im using If (Not (lstTsoCCharge.ListCount = 0)) Then lstTsoCCharge.RemoveItem (lstTsoCCharge.ListCount-1) If (lstTsoCCharge.ListCou...