Im looking for a macro that can get a cell RANGE, the data in the RANGE will be copied then if the checkbox is selected it will copy the same data in the RANGE and add the selected checkbox in next column
Please see my sample below
here is my range below
Capture1.PNG
here is the user form
Capture2.PNG
here should be the result.
Capture3.jpg
no jpg please but an excel sample file for testing
mackypogi, the snapshots aren't entirely conveying your requirement properly. Could you either rephrase, or, as patel suggested, attach a sample with the expected output
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks