![]() |
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