Kapela2017
11-19-2022, 08:04 AM
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...
𝐒𝐡𝐞𝐞𝐭("𝐈𝐧𝐯𝐨𝐢𝐜𝐞"). 𝐑𝐚𝐧𝐠𝐞 ("𝐌𝟒")
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...