I am getting the following error message from the below code "Method or data member not found"
When I select OK the first .vRes is highlighted. I have checked the names on the txt and cbo boxes and these are correct. Can anyone tell me what is causing this problem?
Please Login or Register to view this content.
Thanks
Katie
Hi, Kartie,
what is .vRes? IŽd expected .Value or .Text for Textboxes. And maybe you should use WorksheetFunction instead of Application.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi Holgar,
If I am honest I am not sure what v.Res is. I posted last week as this is to autopopluate cells based on the selection in cbo_CmpName and I was told the error was due to the code getting an empty cell from the VLOOKUP.
Please can you explain the worksheet function, I am very new to this so unfortunately have very limited knowledge.
Thanks
Katie
Hi, Katie,
A link to that thread would have been helpfull.I posted last week as this is to autopopluate cells based on the selection in cbo_CmpName and I was told the error was due to the code getting an empty cell from the VLOOKUP.
If the person who delivered the answer has the same basic naming as I vRes is the result of the VLookUp and would either hold the value if the item is found or an Error.
AFAIK there is no VLookUp for teh Excel application but only the function that can be used as a WorksheetFunction. You could get help about the parameters on the OnlineHelp.
Your code needs to be restructured like this:
You could consider to work with a loop and arrays for holding the Columns as well as the ControlNames.Please Login or Register to view this content.
Ciao,
Holger
Thank you so much for taking the time to help Holger.
I have tried the above code and I am not getting an error of
"Run-time error 9, Subscript out of range"
Do you know what may be causing this? Sorry for all the questions.
Katie
Hi, Katie,
without seeing the file it could be either the path to the workbook or missing or misspelled control be the issue.
Ciao,
Holger
Try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks