objects

Hello, I recently had stability problems with some code and it crashed Excel mamy times. Now when working in the VB edditor the VBA project tree has duplicated the sheet and workbook objects (although the new objects have no code). I have sheet1, sheet11,sheet111, sheet1111(logooutput) etc...

Hi All, I am facing a problem while sorting a group of Objects according to their values. When multiple values entered are same, then Only the First Object is being returned thrice. While I want all the objects to be returned with same values. Please help. Demo...

Hi, I have a very long sub that does multiple things. It is long, complex and sensitive so I cannot post it. However, while the sub is running, all objects on my sheet disappear (Images, command buttons, etc) They reappear when the sub has finished. I have application.screenupdating = False...

Hi, in my work I have used .xlt templates without issues, since the business moved to xl2013 I now use .xltm templates, the edit objects check box under protect sheet will not stay set. Has anyone come across this? are you able to advise? Thank you.

I'm getting my feet wet with objects and started reading Head First Design Patterns after reading http://www.cpearson.com/excel/Implements.aspx The sorting example showing the value of interfaces from cpearson.com worked, but trying to follow along in the first chapter of the design patterns...

Hi All, I have a simple test macro that provides a sheet name in a message box. Name just happens to be a property I show. The macro works fine, and is as follows... Sub WS_Name() Dim n As Integer n = InputBox("enter sheet number") x = Worksheets(n).Name MsgBox x End Sub I wish to change the...

Hi, I have made a macro which write all sheets into one pdf (see below). However, in some of the sheets I have also some objects (PDF). How can I write the sheets and the objects into one PDF? Sub MakePDF() ' ' MAKEPDF Macro ' ' ChDir "Z:\Finans\Regnskap\Avstemminger"...

Hi Excel Experts, I have an excel sheet in which some files are inserted as an object. These objects are placed in column F. When I filter any column, the position of these objects is misplaced? Can somebody guide me how can I keep these objects position fixed even after using filters. Below...

I have created a userform that uses 3 dependent comboboxes to calculate the price of a tour. Once I have filtered through the levels, I am then trying to pull in that tour's specific data such as prices. The program I have works though only up to a point. After I increase the number of objects...

I'm making a table that has some info in various columns here and there, one of the columns I'm looking to use as a reference to some pictures and so it goes from 'Pic 1' to 'Pic 40' - currently just as plain text. What I would like is either: 1. All the pictures on Sheet 2 and by clicking on...

Ok, I've been trying to understand this but right now I'm stuck. This is the piece of code I've been trying to run to copy / paste Sheets("job_tracking").Range("C1").Select However, this does not work. Instead I wind up using this: Sheets("job_tracking").Select Range("C1").Select...

I've drawn a MultiPage object on a spreadsheet. I'd like to add objects on each page of the MultiPage object., but I don't see that it can be done through the Excel interface. I've drawn the objects I need onto the sheet (various lables and such). And I planned to just change their contents...

Hey all! Beginner here :) I get the "Object variable or with block variable not set" not sure why? I'd like the code to input specific values in cells based on months entered in in table header cells. Therefore the code should search for specific month names in each cell within the range...

I am trying to allow user to use a checklist in excel. When I protect the sheet, the checklist is also becomes locked and won't allow a user to modify. I have tried to unprotect the checklist object but it does not seem to make a difference when I limit the protection to just the cells in the...

Hello MrExcel users, Hope all is well. I would just like to ask on what method to use for copying an entire worksheet including the embedded objects into a new workbook. The embedded objects I am referring to are the screenshots (Clipboard to Excel using API) attached to it. It seems that the...

Hello All! This is my first thread. Forgive me if I violate the forum rules. I'm working with a VBA macro that was written by an intern who is now gone. The VBA code uses If-Then-ElseIf statements to hide and show pictures on a worksheet. The following is the piece of the code that I am...

I'm trying to refactor some code, and got stuck when trying to refactor a section that works on cells Public Sub MainSub () MyArray = Range([A1], [B10]) For lngRow = 1 To UBound(MyArray, 1) ' Currently I can do this with no problem ' Cell.Offset(, 6).AddComment...

Hi Guys, I am trying to code a class object that will contain another class object. I am not sure how to go about doing this as I am new to working with classes. I have created a cParts Class and a cBatch Class. I would like to be be able to program this so I can access the data like...

Hello Forum, I would like a macro to do the following: Worksheet event click on CustomerCosts object make group 11 object visible and centered in the window when group 11 object is clicked make invisible. Possible?

Hello, I have a very strange problem that has come up in my excel file. When it was opened the other day, it was completely different! I am using Excel 2013/Windows 8, Btw. All the shapes that I have inserted to use to assign macros are gone. The macros within the modules are still in <acronym...