Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If a user selects "1" in a combobox on a userform I would like to load a set
of questions (named ranges Questions1, Questions2, etc.) in a worksheet "LessonPlan". The range is, for example, I7 for one question, I9 for the next, I11, etc. I7 and I8 are merged, I9 and I10 and merged, etc. Currently, I am using something like: With Worksheets("LessonPlan") Select Case cmb2.Value Case "1" .Range("I7").Value = "Can students identify characteristics/elements Blah" .Range("19").Value = "Can students read, comprehend, and solve blah" Case "2" .Range("I7").Value = "And yet another question" etc., etc. Is there an easier way using my named ranges? I'm wondering if the merging of the cells makes a difference. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ComboBox for a range of cells | Excel Discussion (Misc queries) | |||
determine which values in a range of cells make up a given total | Excel Discussion (Misc queries) | |||
Determine whether a value is in a range of cells | Excel Discussion (Misc queries) | |||
determine if cell address is within a range of cells | Excel Programming | |||
Determine which cells from a specific range equal a certain sum | Excel Worksheet Functions |