ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combobox to determine text for a range of cells (https://www.excelbanter.com/excel-programming/365381-combobox-determine-text-range-cells.html)

Robbyn

Combobox to determine text for a range of cells
 
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.



All times are GMT +1. The time now is 05:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com