How do I use checkboxes correctly?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to have a list of items with checkboxes.
If you check the box then it moves the item to the next sheet.
I can sort of get this to work, however, when it moves it to the next sheet
it is still on the same row as it was in the first sheet.
How can I get the sheet to condense the items so that there are no blank
rows??
 
You will need to keep a track of where the last row on the second sheet is.
Something like

Dim lLastRow as Long

lLastRow=Worksheets("Sheet2").Range("A65536").End(xlUp).Row


Then use the lLastrow variable in the range to place your data

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Check box hero needed please. 3
create a summary page that will take a list and remove empty rows 3
Checkbox issue - Checkbox overlapping when filter is applied 1
Copy checkboxes to another sheet 2
Checkbox Next to Mail Message - How Do I Make It Visible? How Do I Make a Check Appear? 1
VBA to automatically cut, paste entire row based on date input and delete row 0
Excel, assign cells in multiple worksheets from one sheet 1

Back
Top