1. R

    Updating Objects in Different Groups in the One Worksheet

    I have a worksheet where a map has been created using a number of freeform objects. Each of these objects has been assigned the name of the territory which it represents. I then have a list of each territory, with a reference to the fill colour required. I have this working with the first...
  2. jaunito

    Overflow (#6) Error When Assigning a Date Data Type

    I have a class that imports date values from a worksheet and then stores them in a class along with a lot of other information. The problem is when I try to move from the private variable holding the date information to the public property, it is giving me an overflow error. I tested this two...
  3. pvkvimalan

    Deleting Objects from All sheets of a Workbook

    Dear All, I have about 200 Worksheets in an Excel Workbook. All the sheets contain various objects. I initially started by selecting the objects by <Find & Select> <Goto Special><Objects> and delete all. I then managed to find a VBA within MrExcel, that was able to delete the objects, but only...
  4. JackDanIce

    Object unexpectedly changed in VBA project window - how to change back?

    Hi, Working on a spreadsheet containing VBA, last night, closed it and it contained 1 Workbook object (ThisWorkbook) and several Worksheet objects) Today, in the Project window, two worksheet objects have changed icons and showing as Workbook objects?! This is causing an issue with a save...
  5. T

    How to change code to and

    Private Sub Command43_Click() 'Admin Button Bring back nav and other views that are hidden If Text9.Value = "tam.badal" Then 'UnHide the hidden objects in the navigation pane Application.SetOption "Show Hidden Objects", True 'UnLock navigation pane...
  6. S

    Possible to prevent the Microsoft Excel Objects folder tree from expanding on its own?

    Within the Visual Basic Editor on the left side there is the Microsoft Excel Objects folder tree that contains all of the sheets in the workbook. The workbook that I am working in has many sheets and it "pushes down" the Modules folder and Class Modules folder, forcing me to scroll down to see...
  7. G

    Cannot shift items

    I have a worksheet and wish to hide the rows below the last used row. When I select all rows to the last row (52:1048576)and try to hide them, I get the illogical message "Can't push objects off the sheet". I have searched for objects and there are none on the sheet. I'm using Excel 365. Has...
  8. J

    Objects not visible in multipage userform while in edit mode

    Excel VBA beginner I've prepared a userform with a two tab multipage area. I added several labels, textboxes and combo boxes within the first page but had not yet started any code work. I clicked outside the multipage form to edit some other objects and now I am unable to see the multipage tabs...
  9. S

    VBA - Unable to delete objects w/ INTERSECT if using Data Validation

    Good morning! Newbie here, but I've exercised about all the Googling I can do to find the solution and I just have not found one anywhere. Wondering if any expert VBA guys/gals can help a rookie out... Problem: When manually selecting cells that use List-style Data Validation, I can no...
  10. P

    Active Hedings without ActiveWindow cmd

    Hi Is there away to display all headings without using Active Window. The following code works fine but i don't want to open and activate each sheet just to turn on Headings, as this triggers other objects like WS_Actvate etc. For Each ws In Sheets ws.Visible =...
  11. B

    Loop through all objects in a frame

    Hi, I am curious if there is a way to loop through all control objects in a userform frame or do I have to loop through all objects in the userform and look for that particular frame as a parent? For instance, can I use a for each item in frame type loop? My Current code draws a mistype error...
  12. K

    Userform Appearance While Running and in Designer Mode

    Greetings everyone! I searched throughout this forum, and I'm sure I may have missed a similar post. If it exists, I'd be most appreciative if you'd direct me to where I may find it. :hungry: So, here's the scenario. (I) Within a userform, I have a multipage with several tabs, all containing a...
  13. A

    VBA Solution to Creating A Group Of Objects And Moving It

    I have created a groupings of several userform objects. With VBA, how can I move that group of objects into a certain position of a userform frame? Some groups have upwards of 20 objects.
  14. E

    Online Excel Error - Too many objects

    I have created one online excel file, and after 2 months when i try to get into the link, shows me a window and tells me that "Too Many Objects, There are to many objects (charts, shapes, pictures etc to display. ........)" But in this file i don't have, charts shapes etc.. How can i fix it?
  15. Jaafar Tribak

    Data Validation List annoyance !!

    Hi dear forum members, I have the following scenario: 1- Add data validation list to cell A1. 2- Unlock the DV cell (A1) and Protect the worksheet. 3- I have the following code that displays a Msgbox upon double clicking the DV cell (A1): Private Sub Worksheet_BeforeDoubleClick(ByVal Target As...
  16. M

    macro to copy text

    Hello at work we are using one program that basicly tells us what kind of variants to use for some specific objects for example : https://imgur.com/a/ug8OcaT The macro needs to copy from column : AO(V1) to CP(V54) [AO,AP,AQ,AR,AS....ETC] only the last three numbers and then only the last letter...
  17. J

    How to check if two objects have the same property values

    I'm trying to avoid a complicated if statement so, I'm trying to find an easy way to compare the property values of two objects. Not the same reference but the values. There's gotta be a way to do that. Thus far, I haven't found anything but Is and IsNot operators.
  18. H

    Error 91 concerning Objects or with Bloc but I dont have anything like this in my code

    Hello, I have a small problem. My code is running half of the time. When I press on my command button, my code works fine. When I repress on it to try something else, my code isnt running and I have an error 91. I press on end and retry my command button and it works fine. I dont know what is my...
  19. S

    VBA code to copy objects

    Hello, If possible, I would like to improve my code to be able to copy and paste all data in the sheet, including objects and attachments. Right now it looks like this: With WBPrepaid.Sheets("Usage Summary") .Activate .Range("A1:Az150").Copy WBExport.Sheets("Usage...
  20. S

    worksheetfunction.index array form

    I am working with the lines: ArrX = Application.WorksheetFunction.Index(X, 0, 2) ArrTemp = Application.WorksheetFunction.Index(TempSample, 0, 2) DistanceMeasure = (1 - Application.WorksheetFunction.Correl(ArrX, ArrTemp)) * 100 I would like to be able to run a simple correlation using...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back