ActiveX design mode error

Alitsheim

New Member
Joined
Dec 16, 2014
Messages
1
For my company we have been using excel documents with some integrated VBA to speed up data entry and keep uniformity up until last week everything has been working out great. Starting last week we have been having issues when opening up these forms getting errors related to the ActiveX controls, I went through and I deleted the .exd temporary files and this seemed to fix the issues for all the computers but one and I cant seem to figure out whats causing this.

Currently on the form you click an ActiveX label ("Label1") and it goes through the table to pull out the metrics. On the issue computer when you try to run this macro it comes up with an error saying that it cannot create "Label1" and it cannot exit design mode (design mode was not on previously). When I checked the properties of the label it says the label is named "Label2" and in the VBA display for Sheet1, "Label1" doesnt show up in the object dropdown menu anymore.

I've tried deleting this ActiveX control and recreating it, removing it all together and any reference to it in the code, renaming it to something less general but i keep getting the same error. When trying to just rename the current label back to what it should be it comes up with "Label1 is an ambiguous name". I'm unable to recreate this error on any other computer at my company so I'm not sure if this is more of an error on his computer or if it is with excel somehow.



Any ideas on how I can go about correcting this issue?
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,095,146
Messages
5,442,645
Members
405,191
Latest member
wedloski

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top