Using Excel 2007 but I don't think this is a 2007 specific problem:
I have added an ActiveX Textbox which I named "ResultsBox" to sheet3 that I am attempting to copy date into from a range.
The issue is that I have declared a variable to be a textbox and when setting the variable to the textbox on sheet3 and try to use it later in the code, I get a Type Mismatch on this line:
Set x = Sheet3.ResultsBox
I am sure I am missing something obvious. Any thoughts?
Please Login or Register to view this content.
Bookmarks