Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
akk
 
Posts: n/a
Default Pop-up box similar to comments box

Hi

I have a spreadsheet that shows a pop-up box, when i place
the cursor on a cell. For every cell in a column there is
a different pop-up box(looks similar to a comment, but is
not a comment) which has the description. How has this
been done? Also, how do i have the contents of the pop-up
box in a separate column.

Thanks

  #2   Report Post  
akk
 
Posts: n/a
Default

I fugured out that the contents of the pop-up box, is in
data validation, input message. Is there a simple way(a
macro?) to have that moved to a separate column.
-----Original Message-----
Hi

I have a spreadsheet that shows a pop-up box, when i

place
the cursor on a cell. For every cell in a column there is
a different pop-up box(looks similar to a comment, but is
not a comment) which has the description. How has this
been done? Also, how do i have the contents of the pop-up
box in a separate column.

Thanks

.

  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

Putting the input message in a separate column might confuse the users,
but to do that:


Select the cells that contain the data validation, and copy them
Select the cells in the adjacent column.
Choose EditPaste Special
Select Validation, click OK

Select the first set of cells with validation
Choose DataValidation
Select the Input message tab
Remove the check mark from the "Show Input Message when cell is
selected" box
Click OK

Select the second set of cells with validation
Choose DataValidation
Select the Settings tab
From the Allow dropdown, choose 'Any value'
Click OK

akk wrote:
Hi

I have a spreadsheet that shows a pop-up box, when i place
the cursor on a cell. For every cell in a column there is
a different pop-up box(looks similar to a comment, but is
not a comment) which has the description. How has this
been done? Also, how do i have the contents of the pop-up
box in a separate column.

Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #4   Report Post  
akk
 
Posts: n/a
Default

Thanks for this. BUt what i want is that the input message
should show in the second set of cells, not as a pop-up
box but as data in the cell itself.


-----Original Message-----
Putting the input message in a separate column might

confuse the users,
but to do that:


Select the cells that contain the data validation, and

copy them
Select the cells in the adjacent column.
Choose EditPaste Special
Select Validation, click OK

Select the first set of cells with validation
Choose DataValidation
Select the Input message tab
Remove the check mark from the "Show Input Message when

cell is
selected" box
Click OK

Select the second set of cells with validation
Choose DataValidation
Select the Settings tab
From the Allow dropdown, choose 'Any value'
Click OK

akk wrote:
Hi

I have a spreadsheet that shows a pop-up box, when i

place
the cursor on a cell. For every cell in a column there

is
a different pop-up box(looks similar to a comment, but

is
not a comment) which has the description. How has this
been done? Also, how do i have the contents of the pop-

up
box in a separate column.

Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

  #5   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You could use a macro to copy the messages to the adjacent cells. For
example, select the column with data validation, then run the following
code:
'========================
Sub CopyInputMsg()
Dim rng As Range
Dim c As Range
Set rng = Selection.SpecialCells(xlCellTypeAllValidation)
For Each c In rng
c.Offset(0, 1).Value = c.Validation.InputMessage
c.Validation.ShowInput = False
Next c
End Sub
'==================

There are instructions here for pasting the code into your workbook:

http://www.contextures.com/xlvba01.html

To run the code, choose ToolsMacroMacros.
Select the macro, and click Run.

akk wrote:
Thanks for this. BUt what i want is that the input message
should show in the second set of cells, not as a pop-up
box but as data in the cell itself.



-----Original Message-----
Putting the input message in a separate column might


confuse the users,

but to do that:


Select the cells that contain the data validation, and


copy them

Select the cells in the adjacent column.
Choose EditPaste Special
Select Validation, click OK

Select the first set of cells with validation
Choose DataValidation
Select the Input message tab
Remove the check mark from the "Show Input Message when


cell is

selected" box
Click OK

Select the second set of cells with validation
Choose DataValidation
Select the Settings tab
From the Allow dropdown, choose 'Any value'
Click OK

akk wrote:

Hi

I have a spreadsheet that shows a pop-up box, when i


place

the cursor on a cell. For every cell in a column there


is

a different pop-up box(looks similar to a comment, but


is

not a comment) which has the description. How has this
been done? Also, how do i have the contents of the pop-


up

box in a separate column.

Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



  #6   Report Post  
akk
 
Posts: n/a
Default

Thanks! This worked wonderfully.

-----Original Message-----
You could use a macro to copy the messages to the

adjacent cells. For
example, select the column with data validation, then run

the following
code:
'========================
Sub CopyInputMsg()
Dim rng As Range
Dim c As Range
Set rng = Selection.SpecialCells(xlCellTypeAllValidation)
For Each c In rng
c.Offset(0, 1).Value = c.Validation.InputMessage
c.Validation.ShowInput = False
Next c
End Sub
'==================

There are instructions here for pasting the code into

your workbook:

http://www.contextures.com/xlvba01.html

To run the code, choose ToolsMacroMacros.
Select the macro, and click Run.

akk wrote:
Thanks for this. BUt what i want is that the input

message
should show in the second set of cells, not as a pop-up
box but as data in the cell itself.



-----Original Message-----
Putting the input message in a separate column might


confuse the users,

but to do that:


Select the cells that contain the data validation, and


copy them

Select the cells in the adjacent column.
Choose EditPaste Special
Select Validation, click OK

Select the first set of cells with validation
Choose DataValidation
Select the Input message tab
Remove the check mark from the "Show Input Message when


cell is

selected" box
Click OK

Select the second set of cells with validation
Choose DataValidation
Select the Settings tab
From the Allow dropdown, choose 'Any value'
Click OK

akk wrote:

Hi

I have a spreadsheet that shows a pop-up box, when i

place

the cursor on a cell. For every cell in a column there

is

a different pop-up box(looks similar to a comment, but

is

not a comment) which has the description. How has this
been done? Also, how do i have the contents of the pop-

up

box in a separate column.

Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Comments be automatically converted to text cell values? tomdog61 Excel Discussion (Misc queries) 1 January 23rd 05 10:38 PM
How do I change format of all comments in worksheet? Clare Castle Excel Discussion (Misc queries) 1 January 19th 05 04:54 PM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 8th 05 12:43 AM
Changing default font for all comments abbylulu2 Excel Discussion (Misc queries) 1 December 20th 04 07:41 PM
Count Comments Mr Anthony Griffiths Excel Worksheet Functions 1 November 4th 04 05:20 PM


All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"