picklefactory
Well-known Member
- Joined
- Jan 28, 2005
- Messages
- 506
- Office Version
- 365
- Platform
- Windows
Hi folks
Struggling with some VBA.... as usual
I have a new sheet I'm working on. It has 8 columns of data A:H and headings in Row 1. Column A contains a date (d/m/yy) for data to be entered, there could well be multiple instances of the same date, so not a unique value. I have a userform to very simply (He says....) select a start date in textbox1 and an end date in textbox2 and a command button (CommandButton1) to action, which would then hopefully select a range between the 1st instance of start date and last instance of end date, set that as print range, including the headers in Row1 and print to pdf.
Is that feasible, or am I being daft, as usual? Not something I've tried before and not a clue where to start.
Thanks
Struggling with some VBA.... as usual
I have a new sheet I'm working on. It has 8 columns of data A:H and headings in Row 1. Column A contains a date (d/m/yy) for data to be entered, there could well be multiple instances of the same date, so not a unique value. I have a userform to very simply (He says....) select a start date in textbox1 and an end date in textbox2 and a command button (CommandButton1) to action, which would then hopefully select a range between the 1st instance of start date and last instance of end date, set that as print range, including the headers in Row1 and print to pdf.
Is that feasible, or am I being daft, as usual? Not something I've tried before and not a clue where to start.
Thanks