Hello All,
I'm new to the forum and haven't had a lot of time to scour the contents, so if this question has been answered before, I apologize.
Background:
I'm working a creating a spreadsheet as a classification system for certain documents. I realize Excel is not the most elegant solution, but it's what I have to work with.
Problem:
I'm trying to create a userform in Excel that will allow me to select an item from a drop down list and then, mark/unmark a series of checkboxes relevant to the drop down list selection. The problem I'm having is figuring out how to make the Active cell correspond to the selection from the drop down list.
In other words, in my spread sheet I am using Column A as my RowSource for the ComboBox/Drop-down list. In Row 1 I have column headings. Subsequent rows consist of an entry for the document name in colum A and then formulized entries in columns B thru I. Columns G thru AX are the columns that I'd like to be able to populate using my userform checkboxes.
I have the code that will allow me to populate the classification columns (G thru AX) (i.e. I was going to just use the Range.Offset(x,y)), but cannot for the life of me figure out how to be able to select an item from the drop-down list and have the cell containing that data become the active cell in the worksheet.
Any help will be much appreciated. Hopefully this is clear enough, but if further explanation is needed, please let me know.
Thanks in advance.
I'm new to the forum and haven't had a lot of time to scour the contents, so if this question has been answered before, I apologize.
Background:
I'm working a creating a spreadsheet as a classification system for certain documents. I realize Excel is not the most elegant solution, but it's what I have to work with.
Problem:
I'm trying to create a userform in Excel that will allow me to select an item from a drop down list and then, mark/unmark a series of checkboxes relevant to the drop down list selection. The problem I'm having is figuring out how to make the Active cell correspond to the selection from the drop down list.
In other words, in my spread sheet I am using Column A as my RowSource for the ComboBox/Drop-down list. In Row 1 I have column headings. Subsequent rows consist of an entry for the document name in colum A and then formulized entries in columns B thru I. Columns G thru AX are the columns that I'd like to be able to populate using my userform checkboxes.
I have the code that will allow me to populate the classification columns (G thru AX) (i.e. I was going to just use the Range.Offset(x,y)), but cannot for the life of me figure out how to be able to select an item from the drop-down list and have the cell containing that data become the active cell in the worksheet.
Any help will be much appreciated. Hopefully this is clear enough, but if further explanation is needed, please let me know.
Thanks in advance.
