Thanks for all your replies. I ended up just using LIKE and it worked.
I replaced
If prelimarray(i) = quotes Then
with
If prelimarray(i) Like quotes Then
Hi. So heres my problem: I read in lines of text from a text file and place all of them in an array. I then trim off any extra space on the right and left sides. There is one line that has quotes at the beginning and end and will have a comma in the middle. I want to take everything to the...
That definitelly works. I wasn't using a dialog box at first(no idea why), but now that I am, I set the button to default and it works just fine. Thanks for your help.
I know this is a very simple problem, but I didn't find anything about it on the forum. In excel, I have an entry textbox and everytime the user presses the enter key in that textbox, I want it to be the same as if they pressed the submit button which I've already coded. Thanks for any help in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.