resize

Hi! I am wondering if the following trick is possble. Say, I have a spreadsheet with sheets named Project 1, Project 2, Project 3 I want a macro to create and open the following userform: Project Name Sum (Yes/No) Project 1 Checkbox Project 2 Checkbox Project 3 Checkbox ОК Then for example...

I have just found something that seems strange to me. If I resize a range the address of that range does not get resized at the same time. This then prevents being able to step through the range using a For Each loop. Question: do I really have to SET the range so that I can loop through it...

I have experienced an issue with "disappering" checkboxes from cells, very much like described in the link attached. Positioning of form controls using VBA code – Bug in Excel 2010? | Excel Ticker The issue accures when filtering rows and saving the worksheet. On reopening of the worksheet...

Maybe I'm trying to use array's wrong but I need some help with the second/last loop where I am trying to change the contents of an array. Here's the code. Sub FeedReset(byValX As Boolean) Dim nCalc As String, colStatTyp As Integer, ArrayData() As String, Element As Variant ThisSpot 'Another...

Good Day! This should be an easy one. I am attempting to resize a set range to include data that was split and transposed so I can split it again. However I am receiving "Application-defined or Object-defined error." I'd appreciate anyone's assistance in pointing out what I missed and any...

Im Trying to create a userform that behaves similar to normal windows (i.e. can be resized to whatever size the user wants. I have got a fair way with the minimize and maximimize buttons .. now i need to have a grab handle in the corner or make the borders activate resize handles below is the...

I use keyboard shortcuts a lot. I'm on the hunt for something specific. I need to resize Excel pretty frequently - I need to size the whole Excel app tall and all the way to the left, taking up about a third of my screen - then maximize it - then back to tall and left, etc. I can do it by...

I have this chart and I'm trying to resize its points depending on the 'Size' values [D2:D8]. I found some code that should resize the points depending on some values, but it gives me 'Run time error 91 object variable or with block not set'. Here's the said code: Sub...

Workbook Example Hi all, As we know, Excel exposes events for the Worksheet and Workbook objects but for some reason it skipped events related to the application Object ... For example, there is no VBA native way to detect when the user deactivates the excel main window before switching to a...

Please help me with this, I've been looking for a good solution to this for ages! I'm trying to create a macro which runs and resizes merged cell text boxes to fit the text within them. I found this code online on a different forum, which was working (albeit very slowly) a few days ago...

Hi! I realize this forum is mainly for Excel questions, but I have a VBA question for Word. I would appreciate if someone wouldn't mind writing a macro that would automatically resize an image to fit the maximum width of the page, while maintaining the relative height. Or, if you could...

I am searching my entire worksheet for an account number, once I find that account number, I need to search again within a new range. The new range starts with the first cell i searched for (account number) and ends 45 rows down. How can I resize the range after I already searched? Thanks

Hello, I was wondering if someone could help me with the following code? I'm basically trying to create thumbnails then have them enlarge once you click on them. I can make it work for a single picture like "Picture 6" but then I'd have to write a separate macro for each one. Is there a way I...

Hi, I'm trying to search a range to see if any cell contains a wild card End* I'm not sure how to make this code work. Dim cell As Range Set WS3 = ThisWorkbook.Sheets("Sheet3") Set WS5 = ThisWorkbook.Sheets("Sheet5") Set WSH = ThisWorkbook.Sheets("Sheet6")...

Hello, We are using Excel 2007/10 (some users on each). We have an Excel workbook with several connections to SQL Server via 'Data --> Microsoft Query'. All connections work properly and display as tables -- essentially creating a 'dashboard'. We allow users to pass in parameters so the...

I am doing a spreadsheet and I was hoping to link Macros buttons to different cells. I don't want to link it according to matching similar looks or via formulas, just displays. So that the "text box" or "button" will always display inside that cell no matter what. Even if the cell is resized it...

Hi All, I have a dashboard of over 20 small charts that I would like to export as png images at a larger resolution. The macro that I have at the moment exports the charts but does not resize them. In order to export larger charts I think that my code needs to make a copy of each chart at a...

I'm using Excel 2010. I put a TIF file in a header and print it. Then I change the normal font size and print it again. The TIF is squished and squashed depending on the normal font setting. I have not been able to prevent this by any combination of the "lock aspect ratio" or "Relative to...

Excel 2007 I have a dataTable where data is entered via a UserForm in columns A-P, starting on row 6 (headers are on row 5). Columns Q-KN contain all formulas are are hidden during input. Here is the code I have come up with to clear the data, which works ok, except it leave all the rows that...

So I'm creating a bunch of shapes via vba that need to maintain their size as created, but allow the user to drag around (move) if need. I've been digging through shape properties and ShapeNodes but haven't found how to lock the shape from resizing. I need some direction/examples ... if...