Easy VB Q

spg2112 · Apr 28th, 2002, 12:06 AM

OK what's wrong with this? I have a checkbox on a sheet called Splash.

'print?
Worksheets("Splash").Select

If CheckBox("PBranch").Value = True Then
Worksheets("Report").Print
End If

Tom Schreiner · Apr 28th, 2002, 12:08 AM

Hi

Worksheets("Report").Print

Should be

Worksheets("Report").PrintOut

Tom

spg2112 · Apr 28th, 2002, 12:20 AM

Hi TsTom,

Thanks, that was 1 problem solved, but it still craps out at the CheckBox reference. Any ideas?

Steve

Tom Schreiner · Apr 28th, 2002, 12:25 AM

Is the name of your checkbox "PBranch"?

If so:

If PBranch.Value = True Then

Tom

spg2112 · Apr 28th, 2002, 12:30 AM

Yes! Thank you TsTom. I believe that will work. I don't have a printer around now, but that's the fix. Thanks.

Steve

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 28th, 2002, 12:06 AM	#1
spg2112 Board Regular Join Date: Feb 2002 Location: Dallas, TX Posts: 312	OK what's wrong with this? I have a checkbox on a sheet called Splash. 'print? Worksheets("Splash").Select If CheckBox("PBranch").Value = True Then Worksheets("Report").Print End If

Apr 28th, 2002, 12:08 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Worksheets("Report").Print Should be Worksheets("Report").PrintOut Tom

Apr 28th, 2002, 12:20 AM	#3
spg2112 Board Regular Join Date: Feb 2002 Location: Dallas, TX Posts: 312	Hi TsTom, Thanks, that was 1 problem solved, but it still craps out at the CheckBox reference. Any ideas? Steve

Apr 28th, 2002, 12:25 AM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Is the name of your checkbox "PBranch"? If so: If PBranch.Value = True Then Tom

Apr 28th, 2002, 12:30 AM	#5
spg2112 Board Regular Join Date: Feb 2002 Location: Dallas, TX Posts: 312	Yes! Thank you TsTom. I believe that will work. I don't have a printer around now, but that's the fix. Thanks. Steve