R
Robbyn
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.
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.