Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 worksheet
Hi,
I have an excel 2003 worksheet I have around 20 column headings I want to put a label so that I can identify what this column are store and instruction in filling in a certain cell in particular column. I mean I want to put a label on each column heading by not using INSERT COMMENT is there anyway I can do it? So that by the time I point my mouse on the column heading there were pop out to appear on the column where I pointed my mouse on. Thanks for any help I appreciate, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 worksheet
Hi
You could apply Data Validation to the cells, and put your comment on the Input Message tab. Alternatively, you could use some event code on your sheet to bring up different messages. The following is an example for 2 columns, but is set to operate on up to the first 20 columns of the sheet. Add more Case statements for each extra column required. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Row < 1 Then Exit Sub If Target.Column 20 Then Exit Sub Select Case Target.Column Case 1 MsgBox "Only Enter numeric values" Case 2 MsgBox "Only enter Text" Case Else End Select End Sub Copy the Code above Right click Sheet tab View Code Paste code into white pane that appears Alt+F11 to return to Excel This is event code which will be triggered automatically. -- Regards Roger Govier "Denver" wrote in message ... Hi, I have an excel 2003 worksheet I have around 20 column headings I want to put a label so that I can identify what this column are store and instruction in filling in a certain cell in particular column. I mean I want to put a label on each column heading by not using INSERT COMMENT is there anyway I can do it? So that by the time I point my mouse on the column heading there were pop out to appear on the column where I pointed my mouse on. Thanks for any help I appreciate, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Worksheet | Excel Worksheet Functions | |||
excel worksheet name (2003) | Excel Discussion (Misc queries) | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Excel 2003 - Linking Formulas, Worksheet to Worksheet | Excel Discussion (Misc queries) | |||
Linking Formulas, Worksheet to Worksheet - Excel 2003 | Excel Discussion (Misc queries) |