Popup or comment on the column feilds using VBA

abhishek_09 · Nov 28, 2009

We are looking for VBA to show a pop-up or comment when a person clicks on the feild colum in the excel sheet3 tab that summarizes information about that feild from which ever tab the feild is on( Sheet1 tab or sheet2 tab) or shows "not defined" if the feild doesn't appear on either tab.

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5Ctemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5Ctemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5Ctemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format

ther; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-font-family:Calibri; mso-bidi-font-family:"Times New Roman";} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style>
Any help will be appreciated.

lenze · Nov 28, 2009

Hi and welcome to the board!!
Need a little more information!! What to you want the pop-up/comment to say??
Every cell in the column, or just the header cell?

lenze

abhishek_09 · Nov 29, 2009

Hi,

In the work sheet when the user clicks on any cell of a particular column we need to display a pop-up or comment message. The content of the popup/comment message will be based up on some validation, by referencing other work sheets(sheet1, sheet2).

lenze · Nov 29, 2009

So!!!
What Column?
What Validation?
What Sheet?
You may need nothing more than Data Validation Info. You may need a comment. You may need a Message Box. You may need a userform. But, you have to give specifics if you want an answer.

lenze

abhishek_09 · Nov 29, 2009

Thanks for the fast reply.

In the excel work sheet when the user clicks on any cell of a particular column
(for example : when a user points to a particular cell (A2) in column A of sheet3. we need to display a pop-up or comment message. The content of the popup/comment message will be based up on some data validation, by referencing other work sheets(sheet1, sheet2).

lenze · Nov 29, 2009

Let's try again!
Getting a popup or comment is easy, but no one on this board can read your mind. So, unless you tell us what determines the message and where it comes from, we can't help you. The sentence "The content of the popup/comment message will be based up on some data validation, by referencing other work sheets(sheet1, sheet2)." means nothing to us.

lenze

abhishek_09 · Nov 29, 2009

Hi,

I will give you a example.

Right now we have excel template which contain three tabs(sheet1, sheet2, sheet3). We have some text data in the cells (c2,c3,c4.....) of column C of sheet3. This same text is divided in the two different sheets (column D of cells (D2,D3,...)) of Sheet1 and column D of cells (D2,D3,D4...) of Sheet2).

our task is Now when we point to a particular cell(c2,c3..) in column c of sheet3, A pop-up or comment must be displayed showing the current text data in cell (c1,c2...) is in Sheet1, sheet2 or Not specified.

lenze · Nov 29, 2009

So, you want to know if the data you select in sheet3 is on Sheet1,Sheet 2 or neither. Will the data be in the same Row in column "D" or could it be anywhere in column "D" on sheet1 or Sheet2? Could you also give some sample data?

lenze

abhishek_09 · Nov 29, 2009

The data can be any where in column D on sheet1 or sheet2.

The sample data is Project name, current stage, project description, Innovate director etc....

lenze · Nov 29, 2009

I'm still not clear what you want, but maybe this will get you started!!

Code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
If Target.Column <> 3 Then Exit Sub
Dim C As Range
Set C = Sheet1.Range("D2:D" & Sheet1.Cells(Rows.Count, "D").End(xlUp).Row).Find(Target, LookIn:=xlValues)
If Not C Is Nothing Then
    MsgBox "Found on sheet1 in " & C.Address
Else:
Set C = Sheet2.Range("D2:D" & Sheet2.Cells(Rows.Count, "D").End(xlUp).Row).Find(Target, LookIn:=xlValues)
    If Not C Is Nothing Then
    MsgBox "Found on Sheet2 in " & C.Address
    Else: MsgBox "Not Found"
    End If
End If
End Sub

I used a BeforeDoubleClick event instead of Selection_Change. It's much easier to work with and less annoying.
lenze

Popup or comment on the column feilds using VBA

abhishek_09

New Member

Excel Facts

lenze

Legend

abhishek_09

New Member

lenze

Legend

abhishek_09

New Member

lenze

Legend

abhishek_09

New Member

lenze

Legend

abhishek_09

New Member

lenze

Legend

Similar threads

Forum statistics

Share this page

Popup or comment on the column feilds using VBA

New Member

Excel Facts

Legend

New Member

Legend

New Member

Legend

New Member

Legend

New Member

Legend

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock