keys

Hello Everyone, I just made excel searchable drop down by using active x control (Combo Box) and it's working fine But to select the drop down value i have to use Mouse , however i want to select the drop down value by arrow keys. is it possible? Please help

I found some great source code from a website (https://www.rondebruin.nl/win/s4/win012.htm) that enables you to disable the user's ability to use keyboard shortcuts. I've used the blocks of code that disable/enable all keyboard shortcuts — not just ones that are listed. I'd like to adapt the...

I am using vba script to send keys to delete records from a web page. Can I limit this so the send keys are only executed when the URL is a specific value? It works great until it gets to the end of the records and the URL changes. Then it deletes things that should not be deleted.

My latest project has me looking to try and get a count from a mailbox I am delegated for access on. Since I am not able to add in the mailbox to my profile (do not have full access) and have listed on the left side of the Outlook screen I need to go into File option, Open & Export, Other Users...

Hi I have a workbook that I have used for several years that successfully used the following code: Application.OnKey "*x", "CutValues" 'Intercept pressing of CMD+X keys. Application.OnKey "*v", "PasteValues" 'Intercept pressing of CMD+V keys. I have updated to the atrocious Excel 2016 for Mac...

Hi Excel Gurus! I have a sheet I've been trying to sort on three columns. I've been able to sort it on one column, but when I attempt to pass variables to "Key1/Key2/Key3", it doesn't seem to wakt to work. I want to sort it based on last name then first name then ID (Columns B, C, and E...

Im trying to select Rows a161500 through f1123456 (to delete them.) Im currently only familiar with the Ctrl+PgDn Method, is there a more efficient method?

I have built a subroutine for doing multi column sorts. The problem is that the error on the subject line does not tell me where it is breaking. Can experts at sorts eyeball this and see if a problem pops out? Option Explicit ' Must declare variables - clean programming technique Public Sub...

i trying to protect my excel workbook so no one can copy or edit my work,i have successfully disable all main sources of copying my work such as,"right click" on the mouse is disabled and "save as" is also disabled. "ctrl+c" also disabled,but I've notice that when i click the menu key( context...

Hello everyone! Happy Munday! or is it... I have an issue with my Access Database. I have an append query set up and when I attempt to run it, I get the error of Microsoft Access can't append all the records in the append query....it didn't add 4 records to the table due to key violations...

I have been using the following code to only allow the user to enter numbers into a text box on a userform. I am needing to use a similar code to this on a named range to restrict the user from entering certain characters. I am not too sure how to manipulate the following code to make it work...

I just worked with a data set where I needed to create a unique key based on existing information where no unique key was set up as a field. I accomplished it by concatenating (using the & [concatenation] operator) several fields based on what I hypothesized and observed about their content...

Hello, I use UserForm ComboBox_Change (as user input) and I want to get the unique items from Worksheet and list them to UserForm.ListBox1. I get what I want but it performs slowly (in my opinion). I think that it could be written better code but I don't know how. Here's the code: Public c as...