All,
I occasionally have Users enter a string type variable (named str_RC in my code below) that is longer than 255 characters. I've seen some conflicting google search results saying that they are surprised they are getting cut off and ones that say they are not. Is there a way to by pass this issue?
i.e. if my user inputted the string below I'm getting issues after "H096".
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by rkl303; 01-26-2015 at 01:44 PM.
Bump for some help.
Where are you getting the issues?
If posting code please use code tags, see here.
Why are you using Array(RC_Member) when RC_Member is already an array?
Everyone who confuses correlation and causation ends up dead.
Surely people are not typing that long string into the InputBox (which is limited to returning 254 characters)?
You could create a userform with a textbox.
Entia non sunt multiplicanda sine necessitate
Nori - my pivot table is not able to filter past the 255th character(s) in the string so the items
H097, H098, H099, H100, H102, H105, H108, H736, H742, H743, H744, H759, H761, H832, H858, H860, H862, H894, H943, HB01, HB02, HB03, HB04, HB07, HB46, L153"
Are not showing up in my pivot table
----------------------
RomperStomer - Poor coding as I like to use the macro recorder to figure out how to code things. It works though sadly enough.
---------------------
shg - They could and have tried which is why i am here. I added an "add to" function so they could put the next 255 charcters into my filter.
Our cube should has a heirarchy that allows them to filter on this specific region's set of RC's which is roughly 500 characters but sadly the tech team didn't design it that way and our budget now for tech support and actual support we have been getting is a joke and so I am resorting to creating macros for this effor.
I am not familar with userforms at all but from what I am seeing on google I am not sure if I like it. Selecting the ~80 items from a user form seems like the same exact thing as doing it in a pivot table which may have around 500 possiblilties. I guess I could have the user select a different range after selecting which pivot table they want to apply the filter to but that seemed a bit hard to stop 1/4 way through the process to get that information.
A textbox on a form would serve only in lieu of the InputBox, as a means of getting a string longer than 254 characters into the code.
Sweet that worked perfectly shg.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks