window

XL 2010 workbook opens with three windows configured (location on screen and size) as they were when the workbook is saved. XL 365 opens with three equally sized windows in the middle of the screen. Tried fiddling with Windows object and indexing but read somewhere that, for example, indexing...

The following line of code opens the Excel Add-ins dialog window (also accessed via ALT-L H): Application.CommandBars(1).FindControl(ID:=943, Recursive:=True).Execute Can you please advise a similar line of code which would instead open the COM Add-ins dialog window (also accessed via...

I am trying to write a VBScript (.vbs file) that will allow me to activate the current Excel window opened which is just the default "Book1" window after clicking "Blank Workbook" after opening Excel 2016 running on my Windows 10 PC, and activate that Window by bringing it on top (like as if I...

Hi, I have been looking in the forum if anyone have found a solution to the problem when using remove duplicates in Excel for Mac 2016 a popup window appears that doesn't allow the code to continue. I have spent some time looking for a workaround and it seems that issue hasn't been resolved...

Dear Friends, Is it possible hide window bar and close button from a userform in excel vba? Please reply me!

Hi I opened file A.xlsxm and wrote the code below. I ran the code and entered B.xlsx. The code below did not work until I changed the 5th line to the following Sheet1.Move before:=Workbooks(2).Sheets(1) Sub abc() Dim x As String x = InputBox("file") Workbooks.Open (x)...

Hi I have this formula in a cell =CHAR(127)&CHAR(127)&CHAR(127)&"testing" so I got [][][]testing When I print preview (I do not have a printer), I can see all these characters and testing in print view window? Does that mean even when I view them in Print Preview that means they still will not...

Hi I want to increase font size or make the code window bigger so i can see better, it is tiny now but ctrl and scroll up or down does not work. any idea how to make the code window bigger. thanks alot

Have written a macro to identify the last used row in a column: sub_find_last_row() dim last_row as integer lastrow = range("B2"), range("B" & rows.count).end(xlup).row end sub I want to test if a row number was assigned to the variable so I open immediate window: ? Last_row But no number...

Hello. I checked out this forum post: Function for last modified date of cell. I was able to set up a test Excel 2013 spreadsheet ("test.xlsm") with values in column B, cells 2 through 6 and in cells I wanted to have last modified dates in column E, rows 2 through 6. From the spreadsheet I...

I have an Array that I use to populate rows in a Worksheet If rng1.Offset(0, 4) <> "" Then PValue = "DAYS" Else PValue = "ADHOC" If rng1.Offset(0, 5) = "PREVENTIVE" Or rng1.Offset(0, 5) = "REACTIVE" Then AGValue = "PART" Else AGValue = "CUSTOMER" If rng1.Offset(0, 5) =...

Hi all, I would like the all of the sheet names in a workbook toequal to a cell within that sheet. The cell will always be N6. I found thisthread and followed the ‘answer’ that appears near to the top and saved as amacro enabled workbook. I am now working on this macro enabled workbook...

In VBA when I try to view the Locals window, I can't find it. Is there a way to reset the location, or to identify the location of a particular window in the Immediate pane? I am thinking it might be docked somewhere I can't find it, or buried in another window; but I really want to get it...

Hi I have 2 excel files A.xlsx and B.xlsx. I want to open them both in 2 different windows. Right now if I double click on A and then on B they will both open in the same window. I want them to open in different windows as different files. I have windows 10. Thanks Ps: what I did, i clicked...

Hi, As per the title, the below code is not executing when I open the workbook. Sometimes it executes as intended and other times it doesn't. Can anyone suggest a reason why and offer a solution please. The workbook has password protection and is used by other people in my workplace so for...

Hello there I have written a wee program to extract the contents of a cell one character at a time and write them to the Immediate window along with the character position and the ASCII value. The purpose of this code is to determine what any invisible characters in the cell are. At the start...

Whenever I enter anything into a cell, a vba window appears saying can't find project library. I press ok then another window appears with a checkbox highlighted which says there are missing microsoft windows common controls. What do i need to do to get rid of this?

Hi I inserted form controls buttons and active x control buttons. In vba window when i click anywhere on the sheet, i see Properties-sheet1 window, and when i click on any Active X control button, a properties window for that object appears. But when I click on any Form control buttons, no...

I put in the code: Dim wb As Workbook, str1 As String Set wb = ActiveWorkbook And when I look at the info for wb in the locals window for wb it just as no variables. I'm pretty sure that it was working a second ago.

Hi! I have characters which are recognized by Excel itself, however, when referring to them from the VBA editor something gets wrong. For example if I write the expression of ? Cells(1,"A").Value into the Intermediate Window, I get "a?" so VBA can't recognize. (Latin characters) Excel...