Eng-Tips is the largest engineering community on the Internet
Intelligent Work Forums for Engineering Professionals
-
Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA: Dynamically change the .ListFillRange of a ComboBox
Thanks Tarwn, Much of that is what I was doing to find the last row of the range. The problem was was in the syntax of the code with reference to the objects that I was using. After further study, the code below works. Sub Auto_Open ThisWorkbook.Sheets("Demographics").Activate...- RHeilman
- Post #3
- Forum: Microsoft VBA - Visual Basic for Applications
-
VBA: Dynamically change the .ListFillRange of a ComboBox
I have a combo box in a worksheet that displays the names and numbers of a list of healthcare providers. I initially typed the range into the properties dialog for that combobox. Whenever new providers are added to the provider list, I need a macro to determine the new range and...- RHeilman
- Thread
- Replies: 2
- Forum: Microsoft VBA - Visual Basic for Applications
-
How to pass the range as a variable to a chart macro?
Hi VJay, You could have the user input the Row numbers into a cell. For example A1 will contain the starting Row number and A2 will contain the ending row number. Once the numbers are in the cell, you can build the reference. Set lnStartRow = Range("A1").Value Set lnEndRow =...- RHeilman
- Post #2
- Forum: Microsoft VBA - Visual Basic for Applications
