LISTBOX help...please!

Kristina

New Member
Joined
Oct 14, 2005
Messages
4
I need help getting started on creating a worksheet. I would like to create a worksheet where the user clicks in a column, say column M, and a list is displayed where a selection can be made between the choices, "clockwise" and "counter clockwise" but only when they click in a cell in column M. Once a section between the two is made the selection is displayed in the cell that was clicked on and the list that was just displyed is not longer visible. Would it be best to use a list box for this application? Any help with code would be super. THANKS!
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
  1. Just go to the cell in column M.
  2. From the menu pick Data | Validation...
  3. Click on the Allow: control and pick List
  4. A "Source" control will become visible. Simply type Clockwise, CounterClockwise into the textbox
  5. You can adjust other aspects like message and whether the user can only pick from this list (or if he can type in a different value) etc. using the rest of the dialog box.
 
Upvote 0
Is there a way to make it possible to select more than one option from a list, for example by holding the ctrl button?
 
Upvote 0
AFAIK, not with data validation. With listbox controls, yes, you can change the MultiSelect property to suit your needs, but you're going to need VBA to pull values. You may want to just put a "both" option in your list, if that would get you where you need to be.
 
Upvote 0

Forum statistics

Threads
1,218,921
Messages
6,145,230
Members
450,603
Latest member
jpbegley

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top