Enter an activex textbox and link it to a cell and another to a table

[kapela2017]

Greetings dear gurus, My question is the following, I am trying to create a Userform that has a Texbox Active x; to link it to a Cell and another to link it to a table; The cell address is next


𝐒𝐡𝐞𝐞𝐭("𝐈𝐧𝐯𝐨𝐢𝐜𝐞"). 𝐑𝐚𝐧𝐠𝐞 ("𝐌𝟒")



and that of the table is


𝐒𝐡𝐞𝐞𝐭("𝐈𝐧𝐯𝐨𝐢𝐜𝐞").𝐋𝐢𝐬𝐭𝐨𝐛𝐣𝐞𝐜𝐭𝐬("𝐒𝐚𝐥𝐞𝐬")



I know it is declared with the 𝐎𝐋𝐄𝐎𝐛𝐣𝐞𝐜𝐭𝐬 property, but I don't know how to do it; I have also heard mention of the 𝐒𝐡𝐚𝐩𝐞 property, but I don't know anything about that either, thanks for any ideas and guidance you can provide...

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: 𝐄𝐧𝐭𝐞𝐫 𝐚𝐧 𝐚𝐜𝐭𝐢𝐯𝐞𝐱 𝐭𝐞𝐱𝐭𝐛𝐨𝐱 𝐚𝐧𝐝 𝐥𝐢𝐧&#
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[kapela2017]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: 𝐄𝐧𝐭𝐞𝐫 𝐚𝐧 𝐚𝐜𝐭𝐢𝐯𝐞𝐱 𝐭𝐞𝐱𝐭𝐛𝐨𝐱 𝐚𝐧𝐝 𝐥𝐢𝐧&#
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

ok I understand I just give the thread a title and post the link