| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I create a macro in excel?
Can somebody help me to create a macro where the options (points) can be
selected by clicking the list box? For Example: What is your gender? Male Female I want to choose the options by just clicking one of them. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I create a macro in excel?
Hi
Why don't you simply use data validation list with those selections? Select the range. From Data menu, select Validation. Allow:List Source:"Male";"Female" (the list separator depends on your regional settings). OK. -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Peter" wrote in message ... Can somebody help me to create a macro where the options (points) can be selected by clicking the list box? For Example: What is your gender? Male Female I want to choose the options by just clicking one of them. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
| Need to create Excel Macro? | Excel Discussion (Misc queries) | |||
| Create an Excel file using a macro | Excel Discussion (Misc queries) | |||
| error trying to create excel macro | Excel Programming | |||
| Macro to Create PDF from excel with filename... | Excel Programming | |||
Hybrid Mode
