Macro To Make Insert Comment Window Appear Automatically

Sep 11, 2007

I have created an attendance tracker for a team of people at work. It simply involves a grid of the days of the month and on each 'day' (or cell) I have set up the Validation command to prompt the the user to select whether they were at work, on holiday, off sick etc. etc from a drop down box. If they do not change the cell, its defaulted value is that they are in work.

When a user selects the days that they are planning a holiday in the future, they are meant to write a comment on the cells they have changed, to advise when they had 'requested' the holiday.

What I would like is (a macro?) which makes the comment box automatically 'pop up' when they change a cell from its default value prompting them to fill in the details rather than relying on them to 'add comments' manually.

In addition, what would be the best way to 'restrict' them from booking holiday within the next 7 days - we have a problem with people booking holiday on 'lastminute.com' for 2 days time, booking off the holiday on the spreadsheet and saying that they had it planned for weeks!

View 9 Replies


ADVERTISEMENT

Insert Comment Automatically When / Is Entered

Feb 1, 2013

How to make excel automatically insert a comment into a cell when a / is entered into that cell?

The comment needs to simply include the date the / was entered and nothing else.

View 8 Replies View Related

Insert Comment & Format Macro

Jun 3, 2006

I wanted to make a simple macro forinserting a comment, given certain parameters: margins & alignment...but its not working...how would i get this to function properly

ActiveCell.AddComment
ActiveCell.Comment.Visible = False
ActiveCell.Comment.Text Text:=""
With Selection.Font
. Name = "Tahoma"
.FontStyle = "Bold"
.Size = 8
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False...............................

View 2 Replies View Related

Automatically Scroll Window As Macro Runs?

Jul 31, 2014

Just to see how calculations were working out, I was trying to get a macro to scroll down the window as it calculated data.

Sadly, ActiveWindow.SmallScroll Down:=2 was too fast and =1 was too slow!

That's the only command I know to get this to work.

demonstration of a different command. Any way to get the window to scroll automatically to the cell which has just had information inserted into it?

Here's the VBA:

Sub CustomerCategory()
Dim Rng As Range
Dim Dn As Range

[Code]....

View 2 Replies View Related

Make A Cell The Top Left One In The Active Window

Feb 7, 2007

I'm trying find a way in VBA to make a particular cell the top left one in the active window.

View 9 Replies View Related

How To Make Certain Text In Comment Bold

May 25, 2009

I need to figure out how to make certain text bold in a comment using vba. I'm making it so it adds a comment that looks like this:

View 7 Replies View Related

Automatically Insert Picture In Next Cell Macro?

Jun 7, 2014

Basically, I am curious if I were to insert a value into say cell A1, is there any way B1 could display a picture I've saved. To be a bit more specific, A1's value would be 777, and B1's inserted picture would be 777.png saved on my PC. This would need to apply for the whole of the sheet for all the values in column A.

View 5 Replies View Related

Using A Picture Link In A Comment To Make It More Dynamic!

Jan 19, 2010

It mentioned something about getting comments which display dynamic data as if something metioned in the cells will appear in the comment and on changing the data in the cells, the data in the comments also changes with it..

Unfortunately, I could not save that file or remember the website as my Internet went bonkers...

So can someone please help me with the same....

View 8 Replies View Related

Change Comment Box Shape And Make It Default

Jul 1, 2013

i changed the shape of "Comment" box with edit shape. However when i right click the updated shape and click on Set Autoshape Default it does nothing. When I insert a new comment it is back to old shape.

View 2 Replies View Related

Macro To Insert Row With Formulas Automatically When Cell Above Has Date In It

Dec 17, 2009

I am creating a time sheet for a supplier & when the supplier enters a date into column A I would like a new line to be inserted below & include the formatting, formulas & data validation from the row above.

View 7 Replies View Related

Insert Comment Function???

Feb 11, 2009

I'm wondering if it's possible to use a lookup formula to populate cell comments? In other words, I'd like to put a lookup table into a cell, and if the value is not FALSE, have that Lookup table then pull in certain information into the cell's comments.

View 2 Replies View Related

Insert A Comment In A Cell

Jun 9, 2009

When I insert a comment in a cell, my corporate version of Excel displays my employee number. How can Code a cell to populate this employee number.

View 3 Replies View Related

Insert Comment Using VBA By Finding Data

Feb 3, 2014

The list of data is shown in sheet1

In sheet2 I have shown the data that is copied

I have manually shown comments on 2 cells in sheet2 that shows detailed description on how was the total taken.

I need the comment on all the cells from D8 to G11 (not taking the total column) that shows on how was the total taken.
When any entry in sheet1 is inserted or deleted the comment in sheet2 should change accordingly.

I also do not want to freeze the cells D8:G11 as when new entries are made or deleted the columns would increase or decrease.

All blank cells I do not need any comment.

View 7 Replies View Related

Insert A Comment Based On The Value Of A Cell

Jan 18, 2010

I have data validation and conditional formatting set for my sheets. However, I cannot figure out something.

I want a "comment" box (just as if I would click on "add comment") to pop up automatically if the user enters a certain value in a cell.

For example, if cell C4="1" then no further action is required. If cell C4=anything other than "1", then the user would be required to enter a comment. I would also like the comment to autopopulate with the users login id.

I will attach the book I am working on for reference, but I do not have any code written for this as I could not figure out where to start.

View 5 Replies View Related

Insert A Comment Without Unprotecting Sheet

Sep 28, 2007

scenario: sheet & work book are protected to users; however need them to sometimes insert a comment to this sheet.

all columns/rows are locked except columns K, R, Y and every 7th column thru CJ (rows are from 4 - 100).

how do I enable a user to insert a comment without unprotecting sheet / WB? note: there's no pattern, it could be any cell within aforementioned columns.

View 9 Replies View Related

Auto Insert Comment Based On Value Entered

Dec 7, 2009

Is there a way to auto insert a cell Comment when a particular value is entered and then have the Comment copied to a cell in another worksheet in the same workbook?

The value entered into the cells i want this function to work with is from a Validation list. If the cell's value was to change, for instance the user going back to a cell to change the value for whatever reason, I would like the previous comments to remain and then give the user the choice to edit comment or not.

I've had a look in the Forums using search but nothing close seems to be forthcoming.

View 14 Replies View Related

Insert Comment Into Userform Upon Entering A Textbox?

Jan 17, 2012

I have a user-form with around 10 text-boxes. Each one of them has labels.

I was wondering if there was any way to add a function similar to the "insert-> comment" available in excel? So that there would be a tiny marker and when the mouse hoovered over it, some text in a comment bubble would be revealed? Or even better that somehow using VBA that each time you enter a text-box a comment would temporarily appear?

For a variety of reasons I can't just add labels with this info. This info would be instructions on what sort of data you should add to the field, and the instructions in some cases will be quite long and the user-form is too big as it is.

View 3 Replies View Related

RMB Click And All Of A Sudden No Option To Insert Comment

May 21, 2014

When i right click in a cell i have all of a sudden lost the option to Insert Comment.

View 6 Replies View Related

Insert Pic Into Comment For Every Cell That Has Text Containing String .jpg Or .png

May 10, 2009

I need a nudge in the right direction with how to amend the below code so that it :
1: cycles though all cells in a workbook, and sees whether the text reference of the cell contains a picture filename (i.e. searches for .png or .jpg in the cell contents)
3: if (1) is correct, it retrieves the picture from "C:/Users/jeff/Documents/Standards/" and pastes it as a cell comment background in the cell to the right (and overwrites any comment backgrounds that might already exist there)

The code below does something a bit different: it looks in a defined range, then adds a comment with a background picture retrieved based on the text in the cell to the left.

I'm sure this is a pretty basic change, but my VBA skills aren't up to it...I've only just started reading though Walkenbach's Power Programming! I'm using Excel 2007

Sub InsertComment()
'www.contextures.comxlcomments03.html
Dim rngList As Range
Dim c As Range
Dim cmt As Comment
Dim strPic As String

On Error Resume Next

Set rngList = Range("A1:A5")
strPic = "C:/Users/jeff/Documents/Standards/"
On Error Resume Next
For Each c In rngList
With c.Offset(0, 1)...................

View 9 Replies View Related

Comment Boxes Were Automatically Re-sized

Jul 16, 2008

I have a document with about 300 comment boxes, and I needed to enlarge each one to make the information visibly fit in the region. I did this, and was happy.

Then I opened the file on another computer, added a few rows, saved the file, and re-opened it on this one, and all the comment boxes in the original rows (the 300 i had, not the 15 I added later) had been reduced in size and not all the text is visible. Why did this happen? Is there an easy way to re-size all the boxes without doing them one at a time?

View 9 Replies View Related

Use Excel VBA To Find Values In Table And Insert In To A Comment?

Jul 5, 2012

I have a table refreshed from a MySQL database that I use to create a report. I can use this data quite well using formulas in the cells.But in order for me to add more information to the report I use without making it cluttered I need to add some data as comments.

I have created a loop that picks up some cell values that I want to use as criteria but I cant work out how to use these variables to search through the table and get the info I require to put in the comment. In a cell I would use offset/match or index/match to get the required cell value but how do I do this in VBA?

View 2 Replies View Related

Protecting Cells So That Password Is Required Only To Insert Comment

Dec 3, 2013

I've found many resources that tell me how to allow for the insertion/editing of comments within a protected worksheet. When I protect the worksheet, I can select "Edit objects" to allow anyone to insert comments.

However, my issue is that I'd like the Insert/Edit comment functionality to require a password, and this happens to be the opposite of what those resources instruct. I also want the content in those same cells to be editable by anyone.

View 2 Replies View Related

Insert Contents Of A Cell Range Into A Single Comment

Feb 15, 2009

I would like to Insert the contents of a Range of Cells into a single Comment. ie:
The contents of Range A1:A50 into a Comment placed at F1. Is there a Macro that will do this?

View 3 Replies View Related

Insert Text As Comment On Another Sheet Based On Date

Jan 18, 2013

Is it possible to insert text as a comment on another sheet based on a date?

I have Sheet 1, that has 3 columns, Name, Date, Reason

Sheet 2 is a monthly calendar with the dates in E5:AH5 and the names from D6:D10.

What I am trying to do, is when they enter their name, date and reason on sheet 1, I want the reason to to be inserted on sheet 2 as a comment in the cell that matches the date and the name.

View 1 Replies View Related

Automatically Open Comment Box When Data Is Entered.

Dec 22, 2008

I have a spreadsheet where we calculate lost time of machinery and how much money is lost. Every day someone enters the hours that the machines were down and then enters comment in that cell stating what happened or what the resolve was. So for example Machine A runs 24 hours a day, but 12-19-08 it had mechanical issues and was down for 2 hours, so the entrant will enter 22 in that cell, then have to right click back in that cell, go to insert comment and enter "need to change belts." Then if he finds out later that they were down another two hours he would have to change the hours, right click in the cell and edit comment. What we have been coming across is that after awhile he just enters the hours and not the comment. Besides firing a lazy operator I would like to make it more user friendly and ensure that the data entry person is entering the comment.

I would like after the hours are entered in the cell for the comment box to automatically open. I figured there has to be a formula to do it, but i am not at an advanced level. Can you help me?

View 14 Replies View Related

Automatically Make New Tables?

Nov 10, 2009

I got a excel file which i use to add invoices on. But these invoices are numbered and in a book.
1 book has 50 pages, i have to write the amount of $$ on it. But i made this file to enter the amount of money on the invoice. And the sheet automatically gives me the total amount of money which was earned when the book is full.

Now i was wondering if its possible to let excel somehow add 50 new lines with the same formulas used in the first 50 lines. So once line 50 has info enter, excel will add 50 new ones with the correct info(book and page numbers).

Can excel do this with some sort of macro?

View 14 Replies View Related

Copy Contents Of Multiple Comment Boxes And Paste In Single Comment Box

Mar 13, 2014

how to copy the contents of multiple comment boxes and paste in a single comment box.

The big picture is that I have a number of cells with numerical values in and text in comment boxes. I want to be able to click a button to copy the contents of the comment boxes and paste them, along with the numerical value from the cell, into a single comment box, ordered by highest to lowest value within the comment box, then delete the original cells and comments.

I am quite new to VBA but have been coping quite well so far with information of the web and analysing recorded macros.

View 6 Replies View Related

Make Data Recur Automatically?

May 13, 2014

Capture155654.PNG

this is the set of data i have

My problem is now i have to add data of adap.tv in such a way that if a entry comes in with adap.tv and a role already present there in month of jan like happened there with adap.tv in the month of jan and role sr.development engineer it should automatically add data from past month and give value.

I already tried some if and funtions and combination of vlookup.

View 1 Replies View Related

Make Cells Shift Down Automatically

Jun 18, 2009

i need a button to copy the content of A8:C28 and paste in another section of the worksheet, i get the button to copy and paste the selected range, but when i copy and paste again it overides my current paste, i need it to paste my new selection underneath my previous paste.

View 9 Replies View Related

Insert Today Date But Make Sure It Doesn't Change

Mar 19, 2014

I have a button and when I press it, it shows a tick so the user knows when it's been clicked I also want it to insert the date it was clicked but obviously if I use the =TODAY() formula it would change everyday. I need to keep it the same after each day.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved