vbe

  1. 7

    VBA - really no solution for effectively debug locked code?

    Dear VBA experts and fans, I created an excel system that is full of VBA code and we give it to the client - with the code locked for viewing. Of course, there was soon a request that the client encountered an error, so I put "bookmarks" into the whole code - I divided the code into parts...
  2. M

    Which is a better technique, More modules, few routines in each modules

    As I trying to get my coding better, I've been searching for advice regarding which is a better technique. More Modules, each with a unique name referring to the (perhaps) one to five related modules, or fewer modules with more routines in each module. I have figured out it's easier to have a...
  3. J

    Programming the VBE with VBA

    Hi. I read through Chip Pearson's Programming the VBA Editor and his examples are working for me. What I want to do is programmatically control the font in the VBE code modules without using the Font Dialog because that dialog does not exist on the Mac. After checking the Object browser, it...
  4. R

    VBE toolbars absent

    I have no toolbars in my VBE screen. So I can't right click on them. I have tried everything I can think of, including a complete reinstall. After the reinstall the exact same problem was there - so it must have picked up some settings. Please can anyone help, either with suggestions on how to...
  5. Dr. Demento

    (Re-)assigning VBA Editor Shortcut Keys

    I understand how to assign shortcut keys in Excel, but I'm coming up blank on how to run a Sub while in the VBE using a shortcut key. Thanks y'all.
  6. ClimoC

    VBA in Windows10/Excel 2016 Problems and Annoyances

    Howdy Gang. I'm sure I can't be alone in this... We recently had to upgrade to MS Surface Laptops, with 'Office 365' (though we have the local 2016 installs too) and Windows 10. I've noticed the following problems, one of which jut cropped up the other day, and are driving me absolutely...
  7. R

    Where has my VBE layout gone?

    Hello. I am running Excel 2013 on W7 Pro 64bit. I have just recently noticed (when I came back to it after quite a few months) that the configuration of my VBA editor screen had changed. I would like to get it back to the neat way of having the code editor as the largest pane, and the immediate...
  8. M

    How to Update an Excel file Module by using a sub routine from another workbook

    Hello, I have same file is used by my coworkers, sometimes I need to update my codes on those files, I am looking a way to send a new file with most updated codes, so they can update their files simply using a update button in my send file. I know this needs VBE coding, but I am not sure if...
  9. A

    New Access Form Not Showing Up In VBE Collection of Forms

    Hi all, I am adding a new form to a pre-existing split - database. However, when I open up the VBE, I can't find it. I'm certain this is a pretty simple issue, but I can't find anything similar searching online. Any ideas? Thanks,
  10. B

    Thisworkbook Object in VBE crashes Excel

    I have a new Lenovo i7 with 32 bit Office 2016. When I select Thisworkbook object in the VBE, Excel crashes. Searches have not found a solution and extracting to bas or cls files fail to import to clean wkb on selecting the object. Any solutions? Brendan
  11. D

    VBE Codes from excel 2007 to excel 2016

    Hello guys, I have this project and its VBE codes was from excel 2007. So I am trying to copy the codes to Visual basic and also create the same as my project but this time in excel version 2016 just to make it enhanced. Is it possible that it will work successfully? Really appreciated your...
  12. R

    Excel macro executing memorixed code; not including the edits I just added

    Wondering if anyone has ever experienced something where you've edited code and debugging over and over, discovering your edited code isn't included in the execution; instead, a previous interpretation of written code is being executed from memory (doesn't contain the alterations you've just...
  13. S

    View/(Navigte to) the code module of a command button of a specific userform, using vba

    I currently landed up with a requirement, which is , to jump/navigate to the code module view of a command button of a specific userform. While it is easy to view the code window of the sub modules, using the Application.goto, it does not appear to be so , for the userform code window...
  14. B

    Form freezing, Esc key for evey subsequent action required

    Periodically (but quite regularly) when I try to open a user-form it will open up but be blank. If I click the Esc key the form will fill but from that point onward (to click buttons or close the form) I must click the Esc key again before it will accept each action. Also, if I have VBE open...
  15. D

    Macro Shortcut Key Assignments Excel 2010

    I have several, probably more than 10 shortcut keys assigned to my macros. I know I can open each macro and check options to see which key I have assigned, but is there a property in VBE that will tell me which, if any, shortcut key I assigned to a macro? Or is there any handy code that someone...
  16. K

    Excel 2013; User form to add data into looked up cells

    Hello, Unfortunately I'm no big VBE hero and I don't have a basis code to start from, but this is my question. I created an excel document where I enter my expenses. All kinds of calculations happen and conditional formatting to get a quick view of budgets, results, expenses, ... It works...
  17. J

    Entered Cell value to multiply based on target cell value.

    Hi, I am trying to work out how to multiply certain fields on a spreadsheet based on the value of a target cell. For example: D2= 56 (however this value will change on a daily basis) Value entered into D23 is 2, however will automatically change to 112. I need this to happen in numerous...
  18. S

    Error 13 Type Mismatch

    Hey everyone! I am currently writing code to eliminate blanks in a table.. I have to set p = to various worksheets, but I continue to get type mismatch errors. I have tried re cataloguing them to Sheets() or Activeworkbook.Sheets(), etc. but to no avail... can anyone tell me what I am doing so...
  19. P

    Adding Connectors

    I am trying to add a connector to a selected shape. I want the user to be able to select the shape and then run the VBA that will use the selected shape and add a connector. Is this possible?
  20. S

    Autp Populate Cells on a Different Sheet within a Document

    I have been trying to figure this out for 3 days and am at the end of my rope. I am designing a spreadsheet for a construction firm. The workbook contains an the estimate, client proposal and the PO's for 3 different vendors. On the estimate I have a dropdown list for the vendor, category...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top