rootdown42
Board Regular
- Joined
- Jun 8, 2005
- Messages
- 93
I know this is a farily simple question, but I'm afraid I'm still quite a novice when it comes to VB.
My goal is to create a drop-down box with values that will contain the headers for each column in my data set. When one of the values in the combobox is selected, the data set will be sorted by that value. Whether its sorted ascending or descending depends on that particular column of data. The data set, including headers, is a range from B7:S500.
I assume that I should use a combobox for this task. Couple of questions:
1) Should I use combobox from the Control Toolbox toolbar or the Forms toolbar. What's the difference between the two?
2) Should I use the Select Case construct to perform the sort after a value has been selected from the combobox? If so, what would the test expression be?
Sorry for such basic questions, but any help is appreciated.
My goal is to create a drop-down box with values that will contain the headers for each column in my data set. When one of the values in the combobox is selected, the data set will be sorted by that value. Whether its sorted ascending or descending depends on that particular column of data. The data set, including headers, is a range from B7:S500.
I assume that I should use a combobox for this task. Couple of questions:
1) Should I use combobox from the Control Toolbox toolbar or the Forms toolbar. What's the difference between the two?
2) Should I use the Select Case construct to perform the sort after a value has been selected from the combobox? If so, what would the test expression be?
Sorry for such basic questions, but any help is appreciated.