notes

  1. L

    VBA Help Delete Row if 3 conditions met?

    Hello I need help with a bit of VBA code. I need the code to look at Column AI. Column AI can have a value of 0-7. If a Row in Column AI has a value of "0" check column Probed, If it is empty check Notes, if also empty delete that Row. In the example below row 8 would be deleted as AI = 0...
  2. L

    VBA Delete Rows if 2 conditions are met

    Hello I need help with a bit of VBA code. I need the code to look at Column AI. Column AI can have a value of 0-7. If a Row in Column AI has a value of "0" check column Notes, If it is empty delete that Row. In the example below rows 4 & 5 would be deleted as they have an AI value = 0 and no...
  3. D

    Make text box invisible when print to pdf

    I have a textbox that has the text "Please type notes here" and a button that prints to pdf. If no notes are written in the textbox, a blank text box with the text "Please type notes here" will still appear when I print to pdf. How do I make the text box invisible if it contains the text "Please...
  4. T

    Making a Field Mandatory based on a Combo Box Selection on an Excel Form

    Need some assistance please. I have created an Excel Form that has a combo box field - cboCallType. One of the options in the combo box field is 'Other (Please enter details in the Notes Field). What I would like to do is to make the Notes field - txtNotes - mandatory only if the user selects...
  5. K

    Extract words from cells

    Hello, This is my first post here. Any help is much appreciated :)
  6. P

    Regular Expression Pattern question

    Can anyone help with the following.... I am tryiing to write a Regular Expression Patterm to find all instances within a string. The data is a date/time followed by a name followed by (Work notes) or (Shared notes) and then the actual notes. e.g. the string would look like this.... 26/07/2019...
  7. W

    Copy & Paste specific cell in VBA if cell contains any number will not copy and paste if blank.

    <tbody> Value Copy and paste cells notes 15 Since this has a number it will copy and paste =IF($H7<J$5,$I7,0) example of formula I'm copying and pasting Cell is blank since this is blank it will do nothing 210 Since this has a number it will copy and paste <strike></strike> I have...
  8. M

    Adding Checkbox to Notepad

    I have a userform with a multipage, and on each multipage I want to add a command button which opens another userform with a textbox to add notes. So far I have the notes linked to a cell on a hidden page, say "K5", and when there are notes on the page I want a checkbox to be enabled so the user...
  9. J

    Copy entire row into column

    I have a spreadsheet with items similar to below: <tbody> # item code item description item size notes cost 001 Tool Box Prepack 1UN 47.75 CONTAINS: 0001 Screwdriver 1UN 2.79 002 Ladder 1UN 87.79 </tbody> I am trying to create a macro that will search for the word "Prepack" in...
  10. M

    Excel 365 Slow Scrolling Due to Notes and Comments

    An Excel spreadsheet containing any 'notes' (previously known as 'comments' in some earlier Excel versions) is slow to scroll up and down when using the up/down arrow keys. For example, even on a new workbook created as a blank workbook, after one 'note' is added (right-click, new note) in...
  11. M

    Problem Solving Crafting

    Hello, everyone. Sorry IF my question is in the wrong section. Today I would like to KNOW about PROBLEM SOLVING personal (!!crafting-way!!) techniques, some kind of notation may be, PLEASE I would like to hear from you, how you guys resolve problems, or something like code interview. In my side...
  12. V

    Macro transform all notes into comments

    Hi all, Excel 365 here. The newer Excel version changed the old “comments” as “notes” (renamed this way), and added a new feature under the mention “comments”, which works like a thread with possible replies, where on top of input text, the autor is mentionned with a timestamp. I’d like to...
  13. A

    Highlighting Cell When Another Cell Contains Text

    Hello all, I was wondering how I can go about highlighting a cell (i.e. B2) if another cell in its row (i.e. O2) contains text. I don't want a rule that says specific word or words must be entered, just if the cell contains ANY text. I also then want to copy that rule all the way down the...
  14. F

    Power Query - leaving detailed notes of steps

    Does anyone know of a way to keep notes on what each step does in Power Query? When I write VBA, I write up a detailed explanation of what each line of code does so if anyone needs to modify it they can understand the method to my madness. The closest options I can find in Power Query are...
  15. E

    Sending mail via Lotus Notes and displaying a different address

    Hello, I use a macro to send emails with an attached picture via Lotus Notes. The macro is working well but I need to change it so the mail appears to have been sent from a different address than mine. In a different macro I was able to achieve that by adding the following lines. They persuade...
  16. dannyok90

    Notes Userforms

    hi all, I'm thinking of creating a user form to help me track notes and checking. I'm not a novice with VBA and user forms butequally im not a master and maybe not quite an intermediary user either haha. Basically i have spreadsheet sheet for estimating jobs. It has rows representing subtasks...
  17. M

    Copy Selection as Picture Issue

    Morning everyone. I've arranged a bit of code that filters my workbook, selects a named range, copies that range as a picture, opens up a new email on Lotus Notes (unfortunately), pastes that pitcure in the email's body, along with various other text as well as grabbing recipiants and a subject...
  18. tlc53

    VBA User Multiple Input Window

    Hi there, I would like 3x input boxes to popup asking the user for information. When I just add the code for the first one, it works fine. However, I get errors when I add the next two codes. How do I amend the code so that each box pops up one after the other? Thank you! Sub ssFav() Dim...
  19. J

    COMMENTS have become NOTES, and "Edit Note" is missing from right-click menu...

    So MS has renamed the old Comments to Notes, and the new Comments have become threaded conversations. We're now using Notes in the same manner as we used to use Comments. The problem is, EDIT NOTE nor NEW NOTE appear in the right-click menu when in a cell that has a Note, only DELETE NOTE. Is...
  20. G

    Adding rows in between varying group sizes

    To set the scene: I have 800 or so products, each with a unique identifier. These products have associated notes on a system, each with a varying number of notes. These notes are managed on an Excel document. Therefore, on a spreadsheet, I have groups of products. Some are in groups of 2, some...

Some videos you may like

This Week's Hot Topics

Top