All,
I have a program that creates a report in a new workbook. I add checkbox controls to the report via vba and assign what subs should run when clicked. I'm running into a problem where it is assigning the control to the workbook running the code and not the new workbook. I've tried to add the full filename of the workbook along with the sub and this didn't seem to help. Anyone have any ideas what i'm doing wrong? Your help is greatly appreciated.
Thanks!
Currently, it sounds like this is all done in the MasterWorkbook
make NewBook
write code to NewBook
make checkboxes in NewBook
assign checkboxes to new code
What you might do, is
make NewBook
write code to NewBook
write create-checkbox-code to NewBook (including macro assignments)
call newBook's create-checkbox-code
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Doing this will ensure you get the result you need!
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks