screen

Hey Guys Looking for some help as not that expereinced with VBA, i've created a consent form for clients to fill in and that data then gets recorded, there are several pages and each step is recorded step by step as to stop it all being down in one go, i found this was a quicker way to do...

All - Hi! I know how to add a hyperlink to send the cursor to a particular cell. However I need to position that cell in a certain location on the screen. The spreadsheet is really wide - and incorporates a Freeze Panes to ease horizontal scrolling. When I hyperlink to the first cell in the...

I have set Application.ScreenUpdating = False And, it turns off screen updating except for one thing. When i activate a different workbook (with Windows(bo).Activate) the screen changes to that different workbook. Since this is within a loop, it is happening many times. And, this...

Hi All - OK - I got a baffling problem. I have a conditionally formatted cell that "shows" a title if another cell has a value in it or appears "blank" if there is no value in that other cell. The "blank" is just a white font selection. Here's the issue - on the screen it is working...

Hi Guys, Been searching all over and not finding very little about this problem. I have a spreadsheet I keep all my business data in, been using it quite a while. Suddenly it has developed a problem where each time I click on a different cell the screen jumps around and tries to center the...

We are trying to write a script that opens Internet Explorer into a webpage that acts like a DOS screen. We then need to begin typing into said webpage. Below is the beginning code we have managed to make but it does not make the IE screen the current active screen to begin typing into and we...

Hi all, I have spent hours searching through past threads to try and come up with a solution but I have failed and I'm not good at VBA. So your help would be greatly appreciated. I am trying to import a range from a closed workbook into an open workbook. This is what I have so far: Sub...

Hi all Firstly thanks for everyones help previously. Greatly appreciated and helps my knowledge no end. In Range"C16" - if it contains a value i.e. - "XXX" then y screen resizes. There is code of Application.ScreenUpdating = TRUE After this, I do not want anything updated if cells C17:c20...

I have a file that launches several userform with images when opened which serves as a reminder to the critical part of the task. I have 5 reminders to be exact and I want it to be visible all the time. I have already managed to fix the close button but my problem now is that user can move the...

Is there any way that I apply filter on the excel and the screen does not move to the left.

Hello, I have a spreadsheet that I need to filer for a specific set of #'s each time. The code works great when I run the Macro from the VBA Screen, but I am unable to get it to work using a button in excel. It skips over this portion of the coding for some reason. Set rng = Sheet2.Range...

Is there a way that can help me replace the default green splash screen with a userform while opening a file in excel 2016

hi the following code works wonders although before creating a blank new sheet for pasting the screen grab it brings the wrong date and time. what amendment is required to ensure the exact current time date is changed before the screen copy to paste in a new sheet this is the code:- Option...

On my user's screen I want to show the (A1:V37) range of cells in Worksheet1 The Width of (A1:V37) is 977 pixels The Height of (A1:V37) is 642 pixels If the users monitor size => 977X642 then everything works perfect - Scaling is 100% - (A1:V37) is centered on screen and offsets (Top:Left) are...

Struggling to see screen refresh on gauges Have vba code that on click of button waits 3 seconds then changes specific cell value then waits and again changes value The actual cells change but the needle on gauge doesn’t move whilst code running it will change when code finishes to reflect...

How can I make sure that my userform (a) fills the screen, and (b) is in the centre?

I've created a splash screen that opens when the workbook opens as planned, but does not unload after the required 3 seconds, it just stays open and does not seem to call the Sub that should close it. I'm using the code Application.OnTime Now + TimeValue("00:00:03"), "UnloadSplash" , and...

I am trying to make a summary sheet link to other sheets within the workbook via the use of a hyperlink. Within the different sheets, I have certain headings which I would like to link to. The way I have gone about this is to designate the cell with a name and then use that name as the hyperlink...

Does anyone have any suggestions as to how I could set an image to overhang a frozen pane? have a column that I need to highlight with an arrow image, ideally I would like the arrow to span over a frozen panes so that it doesn't move as the screen is scrolled, the top half is fine, but the...

Hi I have a sheet for Work In Progress stocktaking. The sheet is protected except for cells in which order number are typed. Using ENTER or TAB brings you down to the next cell for typing, in between typing cells are 10 rows with lots of lookup (Index,Match). Problem is reaching bottom row on...