focus

Hi This is my first question. I have a command button (SaveChangesBtn) that I wish to set focus to under certain circumstances. On many occasions the button works fine, but occasionally I get an unspecified run time error. It is at the following point in the code POpenIssuesRowID = r.Row -...

I want to display a label only when a specific textbox or combobox has focus. When it loses focus, I want the label to no longer be visible. This code I have does not work: Private Sub UserForm_Click() If Me.ActiveControl = Me.cmbOnbIntResult Then Label1.Visible = True...

hiyas all, Ive looked around the searches and cant seem to find anything that does what I am looking for basically I have a cell with model of car i.e. focus and a cell which recognises if standard metallic or dualtone paint is selected with a 1 2 or 3 number produced from formula the table I...

Hello all, I`m trying to click a link in Internet Explorer using VBA. Tried a lot of things I could think of, but nothing seems to work. I tried everything I could think of or find in the internet, but nothing worked so far. I know that normal .Click is not working in this website, so I use...

I wrote this simple script to auto populate info that i do several times a day. When i runt he script I want to be able to add additional information on the subject line. Right now the typing focus is after the to: email, how can i get it to be at the end of the subject line? Sub actupd8() 'Add...

Thank you in advance for any guidance to this difficult request :eeek:. I have a list of 70 names in a column. I need to randomize this list and hide the names (I'm thinking white font color matching the background). Cell A1 would be blank. The starting position. Using the Enter key or...

Hi, I have a Modeless userform, I want to run a code when UF losses its focus to excel worksheet and also another code runs when it gain focus. My actual concern is when I am changing the current worksheet. I want to reload the comboboxes values based on the new sheet data. Can anybody help...

I am relatively new to access forms and have a question. I have a bound subform which I would like to have data edits and bring the focus back to the incorrect field.. As an example, if I leave the award field as '0', the error message displays "Must enter award amount". When I click "OK", I...

Dears, Is it possible to hide the function that show the focus on a specific cell? You know, if you click on A1, the system will show the focus on A1, the cell will be "bolded"... is it possible to don't let it happen? Thanks again

I am having difficulty installing new network printer via sendkeys, the issue is that I send the first sendkeys code which is show start dialog = ctrl +esc then the next line I wish to sendkeys "cmd", but instead of sending it to the same application, it looses focus and send it to my vba script...

I've tried numerous code snippets over the years and none have worked 100%. I'm finally going to stick with this until I get it right this time. 1) It is being called from Outlook 2013 2) It needs to open up a specific workbook in Excel 2013 Once it gets that far, I'm good. I will do some...

Hi everyone, I am making a simple userform with a couple text boxes and 2 buttons. I am having a terrible time setting up the userform to set the focus of the cursor to my textbox after pressing enter - I want the focus set to this textbox every single time I press enter. This is my code, my...

Hi all, I created a multi-sheet main workbook of many sheets (the destination workbook, which has code) that calls and opens a simple 1-sheet secondary workbook (the source, without any code). When the main is opened each time, it calls the secondary file to be opened. The secondary file is...

Here's my setup: I have a master form, where a user will enter a part number. I then have a subform that is linked to that part number that will tell the user additional warehouse storage locations. I don't want the part number to be repeated in the subform, I just want to show the additional...

I have a VBA code that changes the focus to another OS window. Is it possible to tell VBA to run a different code when the focus returns to Excel? I don't want VBA to force the focus back, it should wait patiently, but as soon as I give it back the focus, a different code should execute. Thank you.

Issue: Bring to front userform when Excel is invisible Background info: I am launching a vbs script from AutoCAD which, in turn, opens a particular excel workbook and initiate a macro. This workbook is opened invisibly (i.e. "xlApp.Visible = False", "Application.Visible = False"), so that the...

I wrote a program that opens PDF files, copies their content into Excel then closes the PDF. This program has to open over a thousand files but after the 186th file it fails to close the PDF and then crashes because I have too many files open. I am closing Acrobat with this command. code...

Note: An idea of how to fix this occured to me after I typed this up, so this issue is solved for me. I decided to post it anyway since it might be useful to someone else. The solution is at the bottom of this post. Greetings, This is what I think should be a simple problem but I can't seem to...

My objective is to be able to use the up/down Arrow keys to step down a list of names in a column. Each step up/down puts a new picture into a Userform, which stays visible and floating above the sheet. All of that works fine if I use the mouse to click on the next cell up or down, but when...

I have a list of names of pictures in a column on a sheet. When I click on any list item, the Selection_Change event loads the selected picture into a userform and displays it. This takes focus away from the clicked cell so I can't then select the next cell up or down with the arrow keys. The...