Tech Support Guy banner
Status
Not open for further replies.

VBA check box

2K views 1 reply 2 participants last post by  rhysduk 
#1 ·
posted wrongley someware else, dont know how to move posts.

i have made some check boxes in VBA, and what to display the outcome in a spreadsheet, how do i do this.

ive been using this tutorial, http://blogs.techrepublic.com.com/msoffice/?p=203 , but this dosent cover it.

any ideas?
 
#2 ·
The tutorial gives you code that should send the information on what check boxes are checked to the spreadsheet.
I've tried the code myself and got an error.

Removing the "Application.WorksheetFunction.CountA (Range("A:A")) + 1" line fixed it for me. What version of Excel are you using?
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top