Solved

Magical Floating ActiveX Control fro Excel Data Validation List

Posted on 2015-02-18
11
57 Views
Last Modified: 2015-02-19
See attached Excel Sheet.

Column "Type" Drop Down List Validation.

I would like it to show the full selection description but after making selection on show the first two digits and ensure the column is re-sized to only the two digit selection.
C--Users-dlehman-Desktop-Part-Order-Form
0
Comment
  • 6
  • 5
11 Comments
 
LVL 45

Expert Comment

by:Martin Liss
ID: 40617355
Try this. all the changes are marked with 'new.
Q-28619595.xlsm
0
 

Author Comment

by:haradaindustryofamerica
ID: 40617415
Is there a way to have this work for only the "Type" column?

The action is being taken on all the other columns that have a Data Validation list but it is applying the same rules as the "Type" column that after selection it is only showing the first two characters. I only want that for the "Type" column.

Also some of the other columns that have a drop list were causing it to go into debug mode at line

"  grngLinkedCell.Value = Left(grngLinkedCell, 2)  "
0
 
LVL 45

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 40617471
I restricted the floating combobox to the Type column and removed grngLinkedCell.
Q-28619595a.xlsm
0
 

Author Comment

by:haradaindustryofamerica
ID: 40617645
Perfect!  Thanks Martin!
0
 
LVL 45

Expert Comment

by:Martin Liss
ID: 40617894
You won't forget to close this question I hope,
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:haradaindustryofamerica
ID: 40619344
Hi Martin,

I am still having an issue with the sheet.

I have copied the file to a network location for user testing.

User A is logged into their desktop system and browse to the shared location.

I have logged into the Terminal Services system as User A and have browsed to the same network location where the file is.

When User A opens the file on their desktop and try and use any drop down list on the sheet they receive the attached error.

When User A logged into the TS system opens the sheet from the same location it opens and works perfectly fine.

Both systems are running Office 2010 - unknown if at same patch level will check that next.

Check Trust Center settings and they are set the same as well.

Any ideas?
C--Users-dlehman-Desktop-Capture.jpg
0
 
LVL 45

Expert Comment

by:Martin Liss
ID: 40619779
I have no idea why you have that problem and I have no way to test it so the attached is the best I can do. The line of code that is causing the problem is trying to get the data validation formula from the target cell so that it can use that formula to fill the floating combobox. The data validation formula was =$Q$12:$Q$33 and what I did was to created a Named Range called "Types" that resolves to that range and used that Named Range in the line of code in hopes that it would help Excel find the range. If this doesn't work you'll need to ask a new question about the problem and hope that someone else can solve it.
Q-28619595b.xlsm
0
 

Author Comment

by:haradaindustryofamerica
ID: 40619927
Martin,

Weird... still does not work. Both systems are same patch level of Office 2010 too.

I will open another question - thank you for all your assistance.
0
 
LVL 45

Expert Comment

by:Martin Liss
ID: 40619963
I'll be interested in the answer so in case I miss it could you post the URL of the new question here please?
0
 

Author Comment

by:haradaindustryofamerica
ID: 40619997
0
 
LVL 45

Expert Comment

by:Martin Liss
ID: 40620000
Thanks.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now