LinkBack URL
About LinkBacks
Hello ALL,
I have below simple code that work with Control Button but not for Command Button (ActiveX Control). Please help me how to make it work with Command Button (ActiveX Control)
Regards,
Please Login or Register to view this content.
tt3
Hello ALL,
I have below simple code that work with Control Button but not for Command Button (ActiveX Control). Please help me how to make it work with Command Button (ActiveX Control)
Regards,Please Login or Register to view this content.
tt3
What do you mean by "doesn't work"? Could you be more specific?
Perhaps attach a sample workbook too so we can see the issue in context.
Beth.
Hi,
That code work with Control Button but show error message when I use with Command Button (ActiveX Control)
Error message: "Application-defined or object-defined error"
***Please help me with a code to work with Command Button (ActiveX Control). I want copy text from TEXTBOX from sheet "CheckIn" to last cell of column A in sheet "Data"
Regards,
tt3
Last edited by tuongtu3; 12-07-2019 at 05:16 PM.
Hi,
If you added a commandbutton with the name CommandButton1 this should work
but also there has to be a textbox on the "checkIn" sheet with the name "TEXTBOXNAME"
grtzPlease Login or Register to view this content.
Last edited by Joske920; 12-07-2019 at 05:12 PM.
Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
If you have been helped, maybe you could click the *
@Joske950:
Got error at this line:
Sheets("Data").Range("A" & Lr + 1).Value = Sheets("CheckIn").TEXTBOXNAME.Value
Last edited by tuongtu3; 12-07-2019 at 05:22 PM. Reason: Added sample
hi,
try this
but be sure there is never a empty cell in your data on column A or 1
your Lr got the number of the last cell +1 and that gave the errorPlease Login or Register to view this content.
Last edited by Joske920; 12-07-2019 at 05:39 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks