Hello all,
I am working on a macro that uses a list box to return a price and discount rate. I have it working as a double click operation, but I want the display boxes to be empty when the user single clicks on something in the list box. I currently get an object error. Any ideas on how to fix this?
I am still getting the error code "run time error '424' Object required" With this updated code.
Please Login or Register to view this content.
Last edited by alexWhit21; 02-28-2019 at 03:26 PM. Reason: Updated Code
You're setting strings try:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
I still get the error code "run time error '424' Object required". Do you know what object I am missing?
.Text is "read only", you need to change it to .Value
Unless Fluff is right I would expect "shtComputers" to be your undefined object.
Thanks for the rep!
Thanks for the Rep.
I assume that all is well?
Ehhh, I still get the same error, but this is for a class so I'm just going to ask my professor in office hours. I'll post the final code then mark the thread as solved after talking to him.
Maybe:
Please Login or Register to view this content.
You'll still need to change the Text to Value
This is what my professor told me was correct. Thank you to everyone for the help!Please Login or Register to view this content.
You're welcome and thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks