Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 4th 06, 03:59 PM posted to microsoft.public.excel.newusers
paul
 
Posts: n/a
Default Message Input with link to different work sheet

i tried to create a hyperlink in a comment and within a dv list but it didnt
work.You might need a small macro to do what you want.I am sure some one will
figure something out!
--
paul
remove nospam for email addy!



"KPM" wrote:

Hi,
What I would like to do, is create a link from a 'hint' (or an error
message) to another worksheet that appears when the user focuses on the
particular cell or gets an error message. How do I create a link (or can I)
through the Message Input dialouge under Data Validation??

More specifically, I am creating a workbook that contains different hardware
and software that is assigned to different people. I have one worksheet
titled 'Lists' and there, I am adding all the items that will be inventoried
or tracked. So, on the 'Lists' worksheet, there is a column titled
'Assinged', which is mostly employee names, but there are also a few room
numbers there as well, so, basically, a PC, laptop, projector or some other
hardware is 'assigned' to a place or thing, for the most part a human, but
not necessarily... then, for example, there is a worksheet titled 'Monitor'
and all of our monitors and the specific information is on that worksheet and
the first column is called 'assigned', this column is a drop down list that
gets its data from the 'Lists' table. On the 'Input Message' dialouge
created using DataValidation, I type a message that explains people should
select from the list, but if the name they are seeking is not present, that
it should be added to the 'Lists' table, under the 'Assigned' colunm. I want
to make the work 'Lists' in the hint message a link to the 'Lists' worksheet.

Thanks for any help.


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
link between sheets get messed when master sheet is sorted Kt Excel Worksheet Functions 1 October 30th 05 01:24 PM
Populating work sheet combox with another work sheet values sjayar Excel Discussion (Misc queries) 1 October 29th 05 03:22 PM
variable in a link where the variable is the name of the sheet darrelly Excel Worksheet Functions 1 October 7th 05 08:24 AM
Buttons to link to a hidden sheet tillytee1 Excel Discussion (Misc queries) 1 September 30th 05 12:29 PM
Is there away to keep "auto save" from jumping to the first work sheet in the work book? Marc New Users to Excel 2 April 21st 05 01:27 AM


All times are GMT +1. The time now is 07:15 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017