Denny White
11-11-2008, 11:09 AM
I would like to know if someone can help me with a very simple question.
I have an extensive VBA program written by someone who has moved up to greener pastures and is no longer available to help me.:banghead:
I have a spread sheet (form) that has data imported into it. One cell in the sheet has one of four possible data entries.
HD1, HD1, QM46, or SM74. These represent four different printing presses.
Toward the bottom of the spreadsheet there are three sets of boxes drawn to represent the printed sheet. I would like a code that can either be in a macro that is already set for printing out the sheets or as a formula that will read what is in the cell and select the set of cells and color them in so that when looking at the form the press sheet is highlighted to very quickly show what press it will print on.:dunno
I am far from a genius at this.
Any help will be very greatly appreciated.
I have an extensive VBA program written by someone who has moved up to greener pastures and is no longer available to help me.:banghead:
I have a spread sheet (form) that has data imported into it. One cell in the sheet has one of four possible data entries.
HD1, HD1, QM46, or SM74. These represent four different printing presses.
Toward the bottom of the spreadsheet there are three sets of boxes drawn to represent the printed sheet. I would like a code that can either be in a macro that is already set for printing out the sheets or as a formula that will read what is in the cell and select the set of cells and color them in so that when looking at the form the press sheet is highlighted to very quickly show what press it will print on.:dunno
I am far from a genius at this.
Any help will be very greatly appreciated.