ctrl

  1. F

    Zoom In and Zoom Out Keyboard Shortcut No Longer Working

    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...
  2. S

    Dbl click is taking me to WRONG cell!

    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)+...
  3. N

    User Form Drop down lists to apply to multiple combo boxes

    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...
  4. Dr. Demento

    User assigned keyboard shortcuts (ALT) not working

    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...
  5. I

    Prefill textbox in userform once open

    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...
  6. I

    Working code needs a new piece of code added

    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...
  7. L

    VBA use CommandButton.name as a string for Range()

    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...
  8. L

    ctrl and scroll wheel does it work in code window

    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
  9. D

    Warning message while doing Ctrl +c

    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...
  10. K

    Ctrl to deselect cells not working

    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...
  11. A

    VBA - Copy table from Excel to Word

    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...
  12. I

    Userform doesnt save 1 field entry correctly

    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...
  13. M

    Looping Through Frames Looping through Option Buttons

    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) =...
  14. A

    Emulate "CTRL + F" in VBA to only FIND data

    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...
  15. A

    error if option button in frame is not selected in userform reopen userform

    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...
  16. P

    Format User Form Controls From within another module

    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...
  17. S

    OptionButtons being treated as CheckBoxes in If statement??

    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...
  18. R

    New row added to table does not bring down formulae and conditional formatting from the line above.

    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...
  19. P

    Dynamic Reference a collection

    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...
  20. D

    VBA - storing variables in worksheet for later refrence

    Hi. We all know that vba can't remember variables after the code finishes. (or could it?). I am writing a program (pos style) in excel vba and sometimes, a code will depend on a condition that was set by a previously (not connected) code. For example, if the user clicks CTRL when a certain...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top