comments box

  1. M

    Comments - Time & Date Stamp

    Hi, If someone can help me find a way to remove or hide the time and date stamp from 'comments' in Excel 365, it will be much appreciated. I am using the comments function to add regular updates to individual items in a workbook and am applying a date against each update in the comments field...
  2. J

    Adding comments based on a filter in a pivot table

    Hi there! I'd like toknow how is possible to make dynamic comments based on a filter in a pivottable by using a Macro or VB. Thank you!
  3. X

    Adding comments through pop up

    I need to add a kind of advanced comments to cell in a worksheet. Say if I click in cell A2 and press a button, a pop up appears that allows me to add comments. The pop needs three values, 1. A drop down menu of two options (D1, D2), 2. Text comment, 3. Text comment. Afterwards, when the...
  4. M

    VBA to open & centre comment on cell selection

    hi, The current code i have to make this work is as follows, but it is clunky and causing the worksheet to be incredibly slow. Any ideas if i can achieve the same outcome in a simpler way? I want column H to have cells that i can click and a comment box will instantly open up in the centre...
  5. J

    Autosize Comments Height, but specify set width.

    Hi all, I have the need to specify comments to Auto-size in respect of height, but have a specified/static width of 9.26cm. The reason for this is that the comments are being used as a guide to requirements that must be met to enrol on a course. The comment box cannot exceed the width of...
  6. J

    Display popup window or comment tag

    Hi Guys and girls Thanks for all the help to date I finally completed my Template - but with it being in "testing Mode - Alpha or Beta" (don't know how you clever ppl refer to it) their has been a few requests to make the document easier to use. Sorted out most of it but i am once again stuck...
  7. D

    insert comment field - how to reset the default font, etc.

    insert comment field - how to reset the default font, etc. the 'insert comment' field defaults to a. font size = 9 b. bold how do I reset the default to something that I prefer?
  8. D

    Interactive comments box

    Hi, I have created a sales dashboard for some product managers. At the top are 2 drop down boxes (the 2nd being dependent on the first, thanks to another thread on here! :biggrin:) whereby the user can select the manager and then select one of the product categories for which that manager is...

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