notes

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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