ctrl

Hello All, I have one userform on which I have a multi pahe. Each tab of multi page has 4 text boxes in column format . Each column having two text boxes. At the bottom of the user form, there are three command buttons (Next Page, Cancel and Close). All controls are added to a collection and...

I am operating Excel 2016. "Ctrl + Alt + -" was my keyboard shortcut for zooming out "Ctrl + Alt + +" was my keyboard shortcut for zooming in. It was great for ditching the scroll wheel on the mouse. As of recently, it has stopped working and I cannot figure out why. Was wondering if anyone ran...

Omigosh I'm about to lose my mind. Why is Excel taking me to the fifth cell in my formula instead of the first?! All that mattes here is that I want to go to CA325 if I double click or ctrl +{ (YES, "Allow directly editing in cells" is OFF) =(CA325*0)+...

Heeeeey guys :) I'm hoping this is a quick simple one:) I have a user form with a combo box that allows the user to select a team name. The next combo box I want to populate with tasks based on the team selected in combo box 1. I also need to apply this same code to 5 more combo boxes. (The...

I am having issues getting keyboard shortcuts with ALT to work and I'm wondering if I'm doing something wrong. The CTRL+SHIFT shortcuts work fine; however, in order to minimize re-assigning native CTRL shortcuts that I normally use, I've moved on to using ALT. However, they don't function at...

Hi, I would like to open the userform & see in TextBox5 NO NOTES FOR THIS CUSTOMER without me having to type it. I have tried like below but i get an error message, run time error 424 object required Private Sub Image1_Click()DatabaseInput.Show TextBox5.Value = "NO NOTES FOR THIS CUSTOMER" End...

Good Morning, I have the working code supplied below but would like an extra piece of code added. This is how it currently works. I use a form to transfer data to a worksheet with the use of pressing the CommandButton1 The worksheet is called DATABASE On the form is TextBox4 were i would enter...

I've got a UserForm with hundreds of small Command Buttons on them that are all named as as either Predicted followed by some numbers or Actual followed by some numbers. I've also got an equal number of cells in the spreadsheet that are named the same as all those Command Buttons. What I'm...

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

It's been a while I have been getting a warning message that pops up on excel when I do Ctrl +c or right click + copy The message says: "There's a problem with the clipboard, but you can still paste your content within this workbook" This issue doesn't happen every time I do Ctrl + c I have...

I usually select a line of data, for example (B2 through F2) by holding Ctrl and dragging across the row. and then hold Ctrl and click on B4 to deselect it and copy and paste it onto another sheet. It used to work like a dream. Now it is not working. I only use it on a single row. No merged...

Hello everyone, I created a small tool via VBA that simply puts a selection of cells in the cache - as you would by selecting a range and pressing Ctrl + C. Then I only have to open a word document and manually insert the table via the shortcut Ctrl + V. This works perfectly in terms of...

Hi, Ive been looking at a userform today & noticed 2 things. Ist thing. When the userform is open and i make an edit to the text within the fields i naturally click on SAVE CHANGES FOR THIS CUSTOMER. I see the saved confirmation message & i am then taken back to the database. Ive noticed that...

Hi all! I am relatively skilled with VBA but cannot find a better way to do this... I have a userform with 63 frames. Currently I'm transferring my data out with 63 iterations of the following: For Each ctrl In Frame1.Controls If ctrl.Value = True Then home.Offset(j, icol) =...

I have been struggling for two days to find the answer to something which is probably simple to most Excel experts. I want to find data only (not replace) using code with a Next and Exit button (on the input box ??), pretty much like what the the CTRL +F keys do in Excel. The find information...

I have a userform that I would like to reopen after an error pops up if option buttons aren't selected within frames. I have a code that works for the error but once the error is closed the userform is also closed. I need the user to be forced to make a selection from both frames in the...

Hi, I have some code that I used to format the controls of a form. I know want to re-use that code to format other/different User Forms My code is: Private Sub UserForm_Initialize() Dim ctrl As Control 'Loop Through each LABEL control on UserForm->frmTxAdd For Each ctrl In...

Basically, I have a little loop, that that sets all CheckBoxes to true or False based on the value of an OptionButton. Works great except that it also meets the IF condition for the option buttons, even though I specifically wrote that I want CheckBox Values to change. Am I missing anything...

I recently got my VBA code working to create a new row in my tables without overwriting data in the line below. The issue I am having is there are some cells in my workbook that have formulae and some have conditional formatting that the new table row needs to inherit from the line above when...

I have six collections of auto generated user form controls Dim MainLabels As Collection Dim Metric1 As Collection Dim Metric2 As Collection Dim Metric3 As Collection Dim Metric4 As Collection Dim Metric5 As Collection And I know I can add a control with this type of code: MainLabels.Add...