ActiveX Textbox vs. Regular textbox

[JennaM]

Hello Again!

I have completed a project to be shared via microsoft office onedrive for my team only to find that I cannot share files that have activeX textboxes....I want to place the code that it is in my activex textbox into a regular textbox so it can be shared but when I debug I get the error: object required....I deleted the other textbox and the name of the new textbox is now textbox1, please help!! I felt like I got to the finish line and someone just picked me up and put me at the start line again...daft.

[AlphaFrog]

I want to place the formula that it is in my activex textbox into a regular textbox

I don't know what this means; "the formula that it is in my activex textbox".

Do you mean vba code instead of formula? If yes, show your code for both the ActiveX and Form-type textboxes. Also, describe in words what you want the code to do.

[JennaM]

I did mean code not formula, my bad (newbie here). The code below is my activeX code, it works great but I need to input this information into the spreadsheet as a regular textbox...I don't have a form type textbox I thought I could just assign code to a regular text box found under the insert tab.

Please Login or Register  to view this content.

[AlphaFrog]

I'm guessing here, but I think you want to change this...

Me.TextBox1.Value = a & b & c & d

To something like this...

Please Login or Register  to view this content.

Make sure the name of the textbox is exact.

Your command button is also an ActiveX control.

You may want to try using Form-type controls, but I don't know if they work with office onedrive or not.

[JennaM]

Thank you so much!! That has been driving me nuts....