Using Embedded Controls to Add Inputs to a Table

[TheScott]

I am trying to understand a simple concept that I seem to have a problem with. I have never used embedded controls on a worksheet before… always controls on a Userform. Their appears to be some difference in the way they operate or are called. I am just trying to understand how to pull information from a Combobox and a couple of textboxes and add them to a table on the same sheet.
At any rate, could someone identify my problem. This is the last iteration of what I have tried. I add the row to the table fine but get different object errors with the controls. The last attempt gives me a Runtime 438 ‘Object doesn’t support this property or method’

EmbedProbExp.xlsm

Regards

Scott

[Leith Ross]

Hello TheScott,

This macro works.

Please Login or Register  to view this content.

[TheScott]

Thank You for your response. Your code got me headed in the right direction but would only operate inside a set sized table (Would not add a new row)
I modified it to add a row and it works fine.

Please Login or Register  to view this content.

My confusion as to naming the objects still exists. I tried to find information on using and identifying OLEObjects on a worksheet but have come up short. Do you have a link or some information that can help me along in understanding how to place and access these controls because I want to try to use them in a couple of different projects and will struggle without a bit more knowledge.

Regardless, I will Thank You again for your assistance and mark this thread as solved

Best Regards

Scott