1. R

    Calling variable from radio button in userform to a module

    Hi Experts, I have a workbook with a User Form with two radio buttons (a,b), an 'OK' Command Button and a 'Cancel Command' Button. On Sheet1("Form") I have a command button that loads the User Form. I also have a module in VBA, where I would like to write a subroutine (called by Clicking the...
  2. D

    Code modification - Log Cell colour change

    Hello, I have found some code on this very forum (Capturing cell color change in VBA) that logs when cell colour is changed on a separate worksheet. How do I adjust that same code so instead of prompting for every single cell it would only prompt once and record the row number instead of cell...
  3. M

    Excel VB, Inventory Manager

    Hello Members, Thanks for being here and hopefully it will be my playground, I have come across a tutorial in Youtube for Inventory Manager. Front End Excel and backend VB. Just the time I attacked VB, An Error messege popped out on Running macro. The error is as follows: Run-time error...
  4. D

    Implement split with address and copy paste using code

    i have two workbooks one that has information put into the other where it will be migrated over to. I can show how it looks below The way the image k ref is, it will contain an address and the split will go in how x ref image shows it. I listed the cells from the other image for reference. Im...
  5. D

    Copy paste from workbook to another workbook

    Using VBA, i want to copy values from entire row F, then when thats done move to G and do the same, then H and so on. With that paste into another workbooks worksheet and paste the values in F then G then H and so on, the shell for both worksheets are the same just workbook 1 has the values and...
  6. U

    VBA Property - Declare in Sheet or Modules?

    Hello, I've been doing some reading recently and many people are saying the same thing with regards to putting code in a worksheet - "Declare only events in a worksheet, nothing more". The statement in itself isn't that crazy, but it makes me ponder if it's a hard set rule of if there are...
  7. S

    VBA to Copy a Module to Another Workbook

    Hi, I've found some code on a few sites that will allow the copying of a module from one workbook to another. The workbook that it is being copied to is being created in another macro so will exist for the import part. I've played with the code for some time now and cannot get it to export...
  8. T

    How to clear all "no fill" cells over 2000+ columns (~75 rows deep) VBA

    Hello PROS! I have a file that had a description column for products that did not match up with the style categories of the stock#'s identified. I took the description column from the original file, copied it, and pasted it in a new doc, applied "text to column" to separate out all the keywords...
  9. M

    Application.CutCopyMode=False on inactive sheet

    Hi All, Newbie to VBA and I'm struggling to resolve an issue. I'm running a module with a button on sheet 1 it copies data to sheet 2 & 3 when it gets to the last copies (Bold) the range remains highlighted on the sheets 2 & 3. I've tried using Application.CutCopyMode = False which only seem...
  10. L

    VBA variable Userform to Module

    Hi All, I have looked at so many different examples, but I'm not able to relate it back to my code. Here's what I have... I was using an input box, but if the user spells something incorrectly, it could pose an issue... so I decided to use a form with radio buttons. Please provide any...
  11. M

    Size limit on Modules in VBA?

    I'm nearing the completion of a macro-enabled workbook that has many modules. I remember seeing some forum posts online that talked about there being a size limit to modules. It seems that the unofficial word is that the limit is 64K for each one. One post I saw suggested to type the...
  12. B

    What are Class Modules

    Hi, I am new to MS Access and have never used Class module in Excel VBA either. My question is more regarding Access, can anyone please help me understand what are class modules. How they are different from regular modules. What are the advantages of a class module or why and when should we...
  13. G

    Run-time error 438. Object doesn't support this property or method.

    Hello. I was unable to find any leads on this by searching. I have a workbook with a sheet containing several combo boxes. The combo boxes are populated by code in the This Workbook module when the file opens. Some people can open the workbook without problems. Some other people get a...
  14. S

    Dynamic unique lists

    Hi all I am trying to create a series of dynamic lists with data from a table searching on 1 criteria to return a second set of data Example data set Make Item 200mm ICP module 300mm DEP module 200mm DSiv module 200mm DEP module 300mm Synapse module 200mm DEP...
  15. H

    VBA code for undo

    Hi, I am looking for a vba code for my module which will undo my works. thank you
  16. L

    new module for recording macros

    Hi I inserted a module and wrote a macro there. Then went to excel and recorded a macro. I went back to VB editor and found that excel inserted a new module and put recorded macros in that module and my first module was not touch. Now when I record any macro, the new recorded macro will go to...
  17. A

    Error 91: Object variable or With block variable not set

    I keep getting the aforementioned error. I have a module (modGlobals) which I use for all public variables... Below seems to be the offending Sub which is in a module. This code is used to populate a list box from entries on a spreadsheet. Sub GetList() If Right(frmMain.Caption, 3) = "V&V"...
  18. D

    For each cntl trigger class module

    Hi I've dynamically created a number of textboxes on a userform. Each textbox was added to a class module with some associated attributes. I also have a number of option buttons to the side of the userform. By clicking the textbox, i can update the text in the textbox from the asociated...
  19. mikecox39

    UDF question: from Chapter 4 VBA and Macros text.

    I'm studying Jelen's book "VBA and Macros" and at the start of Chapter 4, on UDF's, he directs the reader to open a new module in the the VBA Editor and type the following function into the module: Add (Number1,Number2). Can someone tell me what I'm doing wrong because when I enter that line I...
  20. B

    Select a sheet by double-clicking

    Hello, I have a huge workbook with several tabs. I would like to be able to select the tab called "Main" by simply double-clicking anywhere in the spreadsheet. I tried with the code below (ThisWorkbook module) but it does not work :cool: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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