notes

  1. L

    Hover Function in Excel Similar to PowerBI

    Hello, There is a feature in Power BI that I wanted to see if it exists in Excel. There are a lists of assignments that when the user hovers over the number, the description of the assignment appears. It may be one or two sentences. I have been researching to see if there is an equivalent like...
  2. N

    Notes "crushed" by Autofilter--How to prevent?

    I frequently use autofilter on tables/lists containing cells with attached notes. Excel has this *maddening* behavior of changing the size of the attached note based on how many rows have been filtered out. I have attached (in pictures) a sample small table I created with names and ages. I...
  3. L

    VBA - copy from a word doc to Notes and send it - tables looks bad after receiving mail.

    Good Evening!, I am an VBA newbie and need some help. I am writing a small script that should help me. Now i have some trouble with sending an email via IBM Notes. My script opens a word doc. and copy the whole document to the clipboard. After that it opens an new Notes Mail Document and...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. K

    Extract words from cells

    Hello, This is my first post here. Any help is much appreciated :)
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. montecarlo2012

    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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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