MACROs involving scrollbars

  • Thread starter Thread starter HW
  • Start date Start date
H

HW

I have a Excel workbook set up with a report that I run
for many clients. Their records are individually defined
and their names listed in a combo box. As such, when I
select their name from the scroll bar, the report updates
with their info.

I know very little about macros but know there must be a
way to select each name from the scroll bar and then copy
the hardcoded data onto seperate worksheets from Client A
to Z. Currently doing manually. Thanks.
 
Hi,
Click on a name in the combobox to update your report. Now turn on the
macro recorder "tools, Macro..., Record New Macro". Do what you do
manually to create the seperate worksheet. Turn off the macro
recorder.
Go into "tools, Macros..." and click Edit.
Copy the code and post it here. Your questions are now:
1. How can I edit this code so that the worksheet name is replaced
with the combobox name clicked on (plus possibly a creation date?)
2. How can this code be simplified to run faster and avoid screen
flicker.

Showing this group a bit of code is like throwing red meat to a pack
of dogs...

regards
Paul
 
Back
Top