Send parameters in worksheet button > 255 characters

G

Greg Lovern

If I create a Forms (not ActiveX) worksheet button, I can send
parameters in the OnAction parameter, like this:

MyButton.OnAction = "'" & strThisWorkbookName &
"'!'Clicked_My_Button(" & my_arg & ")'"

However, I'm limited to a total OnAction string of 255 characters. I
want to send many long parameters, requiring much more than 255
characters.

Is there any way I can do this with ActiveX worksheet buttons, or any
other way to get around this limitation?

I'm using Excel 2007.


Thanks,

Greg
 

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

Trouble with 255 characters max in a cell 3
The name ... either conflicts with a valid range reference or isinvalid for Excel. 6
Autofilter over 255 characters in a cell? 5
Code OK in XL2003 but Run-time error '1004' in xl2007 0
Reading range w/ 255+ characters throws error 4
copying cells with more then 255 characters to new workbook 4
Copy sheet--Some cells more than 255 characters 2
Array formulas cannot return strings longer than 255 1

Top