Hi everybody,

Currently I'm working on somesort of 'daily report-system' in VBE. I've created a userform that contains a listbox that displays the information of the active sheet.

The users will use this userform on a daily base and the reports are made by day. So every day they select a date from a calendar to create a new report. The userform will create a new sheet with the date as its name.

But... Now I'm struggling with a couple of issues.

1. I want to use a Combobox to search through the entire workbook and display the rows that match the selected criteria in the Listbox.

Example:

When I select the criteria 'high urgency' it needs to show the following..


Time Event Urgency Status
08.00 Blablabla blabla bla blablabla High Solved
07.00 Blablabla blabla bla blablabla High Unsolved
09.00 Blablabla blabla bla blablabla High In progress
__________________________________________________________________

2. I want the users to be able to add new items/events directly in the listbox by using four textboxes.

3. Is it possible to auto-adapt the rowheight of the listbox to its content?

4. Is it possible to copy the text of selected listbox-items to a new Outlook e-mail. (So we can send events with high urgency directly to our manager?

5. Is it possible to change the status of a selected item by using a combobox? I mean, when a item is solved I would like to set its status to solved by selecting the item and then select the status from a combobox.


I hope someone can help with these issues! Thank you all!

Anyone experienced this? I've made a number of comments on my spreadsheet and when I go back to view them, they will only show as a line - can't see the box.

Also, is there a way to view comments in the toolbar?

Thanks,

Julia

Hi, I've just tried pasting something into a new Comment and accidentally hit some keys on my laptop and it's messed up my Comments. I have had this once before, but can't remember how I fixed it.

Comments have lost their Borders.

When you EDIT Comment it stays displayed on spreadsheet - i.e. it doesn't just return to the Cell and Indicator.

However, the text in the Comments is still there.

When you hover the mouse over any cells with Comments, nothing is displayed.

I have gone into Tools-Options-General and made sure Indicator+Comments is selected. Objects is Hide All.

Any ideas???

The Silver Fox

In Textbox 6 of my Excel Userform, I want to enter comments and enter those comments in Column FU.
The Row# depends on the Agent selected in ComboBox 1

How do I show any comments that are already enterred from a previous encounter, and allow any additional comments to be added to the existing comments in Column FU.

This is how I determine the .Row#

Code:

 With Sheets("Sheet1")
        Set rng = Range("E5:E19")
    End With
    With rng.Find(SalesComboBox, LookAt:=xlWhole)
       rsRow = .Row

   End With

Code and suggestions welcome.

Thanks

Hi Everyone,

In excel is it possible to display comments on the plotted charts? I have a sheet with some data and few of those cells has some comments
(right click -> insert comments). Currently I am adding those comments manually on those points on a plotted chart. Just wondering if there is a way to show those comments on the points automatically?

Thanks.

Is there a way to automatically import comments from a Word document into an Excel spreadsheet and show/display the section, page number, line number, and commenter from which it came?

I am saving a copy of my excel files as .mht (single file webpage) files to
display on the intranet. The comments are a helpful, as they work like
tool-tips, but the ouptut of the comments looks awful; numbering the comments
and writing them directly over the data in the cell.

Can I changed this anywhere? Ideally I would like to display "?"'s. I have
located where the actual code is written in the Script Editor, and have been
able to change the HTML code manually, but cannot get it to repeat this on
its own..

Any suggestions?

Thanks in advance,

Michael

I am trying to print a significantly large Excel workbook and save paper. I
have chosen everything that is required for the printer to do it but must
change the document to pdf in order for it to happen. Very frustrating and
wasteful.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I need to enable grouping on a protected workbook. I've found this code to do it, but not sure how to have it work for all sheets:

Code:

Private Sub Workbook_Open()

    With Sheet2

       .Protect Password:="", UserInterfaceOnly:=True

       .EnableOutlining = True

    End With

End Sub

In Excel 2002, I am looking to identify and delete duplicate records in an
entire workbook, not just in one sheet. Many thanks for any help anyone can
offer.