| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Excel
Hello,
I have different kinds of checklists based on the requirements. As of now I have a separate excel sheet for each of these checklists. Is it possible that I can have everything in a single excel sheet wherein if a user selects few options he will be shown with the corresponding checklist items. Can that be done in excel. If so could anyone provide me with some guidelines as how to do it Thanks Harish |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Excel
My first thoughts, Harrish, is to create one workbook with your checklists
on different worksheets. A UserForm in the VBA project could open the workbook to the sheet indicated by the user's inputs, keeping the others hidden. HTH Ed "Harish" wrote in message om... Hello, I have different kinds of checklists based on the requirements. As of now I have a separate excel sheet for each of these checklists. Is it possible that I can have everything in a single excel sheet wherein if a user selects few options he will be shown with the corresponding checklist items. Can that be done in excel. If so could anyone provide me with some guidelines as how to do it Thanks Harish |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Excel
Hello Ed,
Could you elaborate on what you have mentioned. Thanks Harish "Ed" wrote in message ... My first thoughts, Harrish, is to create one workbook with your checklists on different worksheets. A UserForm in the VBA project could open the workbook to the sheet indicated by the user's inputs, keeping the others hidden. HTH Ed "Harish" wrote in message om... Hello, I have different kinds of checklists based on the requirements. As of now I have a separate excel sheet for each of these checklists. Is it possible that I can have everything in a single excel sheet wherein if a user selects few options he will be shown with the corresponding checklist items. Can that be done in excel. If so could anyone provide me with some guidelines as how to do it Thanks Harish |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Excel
Re-reading your original post, I may have gotten the wrong idea. I think
when you said you have "a separate excel sheet for each of these checklists", I assumed - perhaps incorrectly - that you have a separate Excel *workbook* for each checklist. My first idea was one workbook with all of your lists as separate sheets in one workbook. If you have 10 checklists, you would have one workbook with 10 sheets. When the workbook opened, a UserForm with option buttons, drop-down list, or other input control would pop up, allowing the user to select which checklist was required, and then show only that worksheet, hiding all the others. Another idea - and maybe closer to what you wanted - would be to put the checklists down one sheet (list 1 would take, say, rows 1-25, list 2 rows 26-50, etc.). A form would take user input to determine which list was required, and take the user to the first row for that list. Any rows not needed for that checklist could be hidden. Or the workbook could hide the first sheet and open to a second sheet, which explains everything and allows the user to make inputs(s) by selecting or inputting a value into a cell. A button on the second sheet would evaluate the input, hide the second sheet, show the first sheet, and take the user to the correct list. Anything sound like what you want? Ed "Harish" wrote in message om... Hello Ed, Could you elaborate on what you have mentioned. Thanks Harish "Ed" wrote in message ... My first thoughts, Harrish, is to create one workbook with your checklists on different worksheets. A UserForm in the VBA project could open the workbook to the sheet indicated by the user's inputs, keeping the others hidden. HTH Ed "Harish" wrote in message om... Hello, I have different kinds of checklists based on the requirements. As of now I have a separate excel sheet for each of these checklists. Is it possible that I can have everything in a single excel sheet wherein if a user selects few options he will be shown with the corresponding checklist items. Can that be done in excel. If so could anyone provide me with some guidelines as how to do it Thanks Harish |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Excel
Hello Ed,
I have followed your suggestion and was successful in implementing it. Thanks for the help Harish "Ed" wrote in message ... Re-reading your original post, I may have gotten the wrong idea. I think when you said you have "a separate excel sheet for each of these checklists", I assumed - perhaps incorrectly - that you have a separate Excel *workbook* for each checklist. My first idea was one workbook with all of your lists as separate sheets in one workbook. If you have 10 checklists, you would have one workbook with 10 sheets. When the workbook opened, a UserForm with option buttons, drop-down list, or other input control would pop up, allowing the user to select which checklist was required, and then show only that worksheet, hiding all the others. Another idea - and maybe closer to what you wanted - would be to put the checklists down one sheet (list 1 would take, say, rows 1-25, list 2 rows 26-50, etc.). A form would take user input to determine which list was required, and take the user to the first row for that list. Any rows not needed for that checklist could be hidden. Or the workbook could hide the first sheet and open to a second sheet, which explains everything and allows the user to make inputs(s) by selecting or inputting a value into a cell. A button on the second sheet would evaluate the input, hide the second sheet, show the first sheet, and take the user to the correct list. Anything sound like what you want? Ed "Harish" wrote in message om... Hello Ed, Could you elaborate on what you have mentioned. Thanks Harish "Ed" wrote in message ... My first thoughts, Harrish, is to create one workbook with your checklists on different worksheets. A UserForm in the VBA project could open the workbook to the sheet indicated by the user's inputs, keeping the others hidden. HTH Ed "Harish" wrote in message om... Hello, I have different kinds of checklists based on the requirements. As of now I have a separate excel sheet for each of these checklists. Is it possible that I can have everything in a single excel sheet wherein if a user selects few options he will be shown with the corresponding checklist items. Can that be done in excel. If so could anyone provide me with some guidelines as how to do it Thanks Harish |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
