LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 75
Default Start Macro after user selects a choice from a pick list

Can anyone help me develop a process for starting a macro, or sending a user
to different parts of a spreadsheet, after a user on a form selects a choice
from a pick list.

Here is the situation:
The user is completing a spreadsheet with multiple choices. The user must
make these selections using a series of pick lists nobody can spell these
days! Depending on the choice of the user, they will need to complete
different parts of the spreadsheet. For example:
Do you want apples, oranges, pairs, bananas, etc? They select one. If the
answer is apple, they then need to answer: Type of apple from another pick
list; then color from yet another pick list, then where grow etc!

My programming skills are remedial at best! This seems very simple,
however, I cant seem to find a solution so any help would be appreciated
greatly! Thanks!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro stop if file in use by other user? Bry Excel Discussion (Misc queries) 5 August 11th 06 04:27 PM
Validation list that also allows user entry? Angela Dennis 911 Excel Worksheet Functions 6 July 20th 06 02:33 PM
can I build a user pick a value from a list to insert into a cell krisfr Excel Discussion (Misc queries) 2 July 20th 06 12:21 AM
delete a macro that isn't in macro list Jane Makinson Excel Discussion (Misc queries) 3 March 13th 06 01:10 PM
Inserting Blank Rows Macro? Michael Saffer Excel Worksheet Functions 2 November 9th 04 06:23 PM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"