Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-03-2023, 04:29 AM
Guessed's Avatar
Guessed Guessed is offline Symbol Marking with Dropdown list from an Ecxel Windows 10 Symbol Marking with Dropdown list from an Ecxel Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,997
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

This is not a simple task but it is possible. I'm not sure if you want the solution to be dynamic (updated automatically by extracting the current list from Excel) or static but you would need to develop this in stages and learn how to do this with a static solution first. Once you have the knowledge of how to do this with a static shape, you can build on that to get more automation.

To help you learn how tasks like this can be done it is important to start off with correct terminology so your web searches can be more productive. When you say 'Symbols that I can store in a template' I think the terminology is not quite right.

A template is a Visio document which is used to create new Visio documents
A Visio document can contain shapes but usually a shape is stored in a special library-type file called a Stencil. Stencils can be accessed by any document which makes the shapes in that stencil available to the document.
A shape is what you appear to be calling a 'symbol'.

Now, when you talk about accessing Excel for a dropdown menu, this is possible but would be a strange thing to do since it would take 5-10 seconds to open and interrogate the Excel workbook and this is a lot slower than most users would be prepared to wait. But you could import the Excel data (if you have Visio Professional) to make that part a lot more responsive.

I think you might need to post more details (like Excel and Visio docs) so I can see what it is that you want. I'm not sure how the 'symbol' is going to come from Excel.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Symbol Marking with Dropdown list from an Ecxel Using a dropdown list MaineLady Excel 2 04-21-2021 03:29 AM
Find/replace - symbol for all numbers or symbol letters (Word 97) Genericname1111 Word 10 11-10-2019 10:37 PM
Can't add symbol to multilevel list GreySquirrel Word 5 10-22-2018 02:08 PM
Selection of a dropdown creates another dropdown wih the list krishnamurthy.ka2810 Word VBA 1 04-26-2018 11:44 PM
Help!! Dropdown List christo16 Word 1 06-29-2015 05:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft