The below VB will create a text file based on the attached file. what I am trying to do is add a checkbox (in cell F7) to that sheet, that if it is checked then the values are added to each line (last text in bold below). Thank you.
VB
Please Login or Register to view this content.
Add this to the end of each line...
& IIf(Sheet1.CheckBox1, vbTab & ActiveSheet.Range("F9").Value, "")
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks