ctrl

I have a "VERYHIDDEN" worksheet named "prov" in a workbook and I want to show and browse it without editing option - just view - with the assigned keys > say, Ctrl + P or Ctrl + V to open it and after closing - the said worksheet to return to the original view setup (veryhidden) how would the...

Hi I have the below formula that I need the cell references to increment when I drag down a column. =IF(ISBLANK([CATraxx_Album.xlsx]Track!$H$2),"",""&[CATraxx_Album.xlsx]Track!$H$2& "") what i need it do do when copied downward is...

I am struggling with VBA code to loop through ComboBoxes on a userform and perform actions. The userform has other controls on it besides ComboBoxes. I've tried: Private Sub UserForm_Initialize() Dim ctrl As Control numTemplates =...

Hello. This may be a simple question but, I am new to this. I would like the caption of each visible label to show in rows of column A and the value of the textbox to go in rows of column B. On the nextrow2 variable, I'm getting an error that say "object does not support this property or...

I have a userform that depends on various data types. When the user opens the form, all fields are hidden and based on the selection from drop down cetain fields are visible and others are hidden. On data submission, data will be copied into an excel worksheet. I’m trying to write a code to...

Hi I have this in my module and I must of done something earlier that I don't know of and when I open an excel sheet I get a break. Its breaks at .Caption = strCap and I don't know why also it says commandBarbutton failed Does anyone know why this is happening thanks Function...

Hi I was reading the article below. User use Ctrl + J as a delimiter. I have found that using Ctrl + J or not I will get the same result. Excel break the text into columns without putting anything under [] other Thank you.

I've already gone through the steps of going to language settings and putting Not Assigned on both the Ctrl and Alt buttons. It worked for about a day and then it just stopped working again. Is there a way I can assign this same keyboard shortcut to a macro?

Hi, I have a list of data, for short's sake A1:A10, what I've been previously doing is the following combination, CTRL C, ALT TAB, CTRL V, ALT TAB, DOWN ARROW, CTRL C, ALT TAB, CTRL T, CTRL V, ALT TAB, DOWN ARROW, CTRL C, ALT TAB, CTRL T, CTRL V.. this can go on for over 100 rows which is quite...

Hi, What I’m trying to achieve is if I was to google image a picture and the copy it, I want my macro with CTRL E to paste it into selected cell and then resize it to 3.77 cm height and 2.37 cm width. Thanks

Hello all, I have a custom right click for a series of ranges on on of my sheets. But I want to have a different range of cells with different right click options. is that possible? here's a shortened version of my code: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As...

Can only copy/paste a cell once, then paste is greyed out I have excel 2013 and on any cell I copy either Ctrl C or Copy from the lsiting then move to any other cell I can do Ctrl V or Paste once, then the cell contents disappear from the clipboard and the Paste option is now gray. I tried...

In the macro naming window, there is an option to create a shortcut to run the macro. But there is only one modifier key option (Ctrl) with an empty field for the character to complete the combination. Why is there only one modifier option and how do I know that the character I choose isn't...

I’m trying to use this script to determine if UserForm controls are true or false. I wanted to use case statement. I cannot understand what is wrong with the script where you see the statement this is not working. I’m wanting to know if Textbox or Combobox has values. I tried using Else...

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?

Is there any way to write a public function that will trigger if code execution is ever cancelled by a user. For security reasons, I would like to program it in so that if the user breaks the code or if there is an error I didn't catch the program automatically brings the user to a "safe" place...

I have a sheet with heavy data validation. The sheet is also password protected so you cannot select cells that are locked. Currently A11 is the first unlocked cell in the workbook. Why doesn't Ctrl+Home take me to A11?

Hi, I have a macro in one of my excel files that basically selects a list of cells from another page in the workbook and pastes those into the active cell. (it is a list of locations and nominal values) for example I would run this macro and paste it into say cell H30 tand it would fill in down...

"Huh?! Chinese?! I don't even speak Chinese!!! Well, we'll just pop into the old regional settings and get this taken care of!" And thus began a rather frustrating quick and dirty scouring of the internet. I had just bought a new notebook and was running Vista. I'd hopped into Excel for the...