Search:

Type: Posts; User: ExcelBaap

Search: Search took 0.01 seconds.

  1. Find Replace '?' (Question Mark) and '*' (Asterisk) Characters using VBA

    Generally, when you write a Find/Replace statement in VBA, it is difficult to replace '?' (Question Mark) and '*' (Asterisk) Symbols/Characters with anything else. It ends up replacing all the...
  2. Replies
    0
    Views
    664

    Housie / Tambola Game in Excel VBA

    I have created Housie / Tambola Game in Excel using VBA. It works on Random Function called 'RANDBETWEEN', which is called from Excel Functions in VBA using the code WorksheetFunction.RANDBETWEEN....
  3. Replies
    0
    Views
    318

    Excel VBA Macro Security

    This is a little information about VBA Macro Security:

    In Microsoft Excel, you can change the macro security settings to control which macros run and under what circumstances when you open a...
  4. Replies
    0
    Views
    334

    How to make an Excel Cell Blink?

    To be able to achieve this, we need to write some code in the Worksheet module that will trigger an action when any change happens.

    Here's the code to be written in Worksheet module:


    Option...
  5. Efficient way to search an Excel sheet through a User Form

    In this thread, we have created a User Form to search efficiently through a sheet with data. We have used Advanced Filter and formulas to ensure that the performance is good.

    Attached is a...
  6. Triggering a macro upon change in worksheet

    A macro can be triggered either by a button or by some other events such as change in worksheet cells or opening a workbook or closing a workbook, etc. If you want to trigger a macro when a user...
  7. Replies
    0
    Views
    2,539

    Useful Excel Keyboard Shortcuts

    Here are some useful Keyboard Shortcuts in Excel:

    3
  8. Save all images in a sheet to a folder using VBA

    If there are multiple images in an Excel file which you want to save in a folder location, here's what you can do to automate the process:

    1. Open Visual Basic Editor (Press Alt + F11)
    2. Insert...
  9. How to extract all Cell Names in a file?

    Named Ranges are those that are created manually by selecting a cell or a group of cells and giving a name in the Name Box. They can also be created/edited/deleted from Formulas >> Name Manager.
    ...
  10. How to extract cell comments of all sheets using VBA?

    Sub GetComments()

    Dim cell As Range
    Dim counter As Long, k As Long
    Dim ComStr As String

    counter = 0
    For k = 1 To ThisWorkbook.Sheets.Count
    ...
  11. Replies
    0
    Views
    328

    The Excel Object Model of VBA

    Here are the details of The Excel Object Model of VBA. There is a specific syntax of connecting with Excel Workbook Objects from VBA. Some examples of Excel Objects are Workbook, Worksheet and Cells....
  12. Replies
    0
    Views
    303

    How to start writing macros?

    Step 1: You need to open the Visual Basic Editor. You can do that by pressing Alt + F11.

    Step 2: You need to add a new module in the Visual Basic Editor by selecting Module on that editor's Insert...
  13. Open all files in selected folder and perform some operation

    If you want to allow the user to select a folder location, open all files in that folder and perform some operation, this is the code you can use:



    Sub TestCode()

    'Initializing Variables...
  14. How to count number of occurrences of a character in a string?

    Below Function can be used to count the number of occurrences of a character in a string:


    Public Function CountCharInString(OriginalStr As String, CharToBeCount As String) As Long

    If...
Results 1 to 14 of 14