| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheet direction, extract data from comment
I would like to change the sheet direction by default.
Also if it is possible, how to extract data from comment to cell. -- MFS22 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sheet direction, extract data from comment
You can try the below UDF. To try this launch VBE using Alt+F11. Insert
module and paste the below code. Save and close VBE. Get back to workbook. Sub GetComment(varData) GetComment = varData.Comment.Text End Sub Add a comment to cell A1 B1 = GetComment(A1) If this post helps click Yes --------------- Jacob Skaria "MFS" wrote: I would like to change the sheet direction by default. Also if it is possible, how to extract data from comment to cell. -- MFS22 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sheet direction, extract data from comment
Revised...
Function GetComment(varRange As Range) As String For Each c In varRange If Not c.Comment Is Nothing Then GetComment = GetComment & c.Comment.Text & "," End If Next End Function If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: You can try the below UDF. To try this launch VBE using Alt+F11. Insert module and paste the below code. Save and close VBE. Get back to workbook. Sub GetComment(varData) GetComment = varData.Comment.Text End Sub Add a comment to cell A1 B1 = GetComment(A1) If this post helps click Yes --------------- Jacob Skaria "MFS" wrote: I would like to change the sheet direction by default. Also if it is possible, how to extract data from comment to cell. -- MFS22 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sheet direction, extract data from comment
Hi,
You may want to refer to question 46 of the following link - http://ashishmathur.com/replies.aspx -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "MFS" wrote in message ... I would like to change the sheet direction by default. Also if it is possible, how to extract data from comment to cell. -- MFS22 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract data from range,and place in the same sheet | Excel Discussion (Misc queries) | |||
| Extract Data by keyword and export to new Excel sheet | Excel Worksheet Functions | |||
| Adding a Comment-Column to an external data-sheet | Excel Worksheet Functions | |||
| macro to extract data of a selected sheet | Excel Discussion (Misc queries) | |||
| Help me, compare 2 sheet and extract the match data into the new sheet. | Excel Discussion (Misc queries) | |||
Linear Mode
