• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 94
  • Last Modified:

Magical Floating ActiveX Control fro Excel Data Validation List

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
haradaindustryofamerica
Asked:
haradaindustryofamerica
  • 6
  • 5
1 Solution
 
Martin LissOlder than dirtCommented:
Try this. all the changes are marked with 'new.
Q-28619595.xlsm
0
 
haradaindustryofamericaAuthor Commented:
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
 
Martin LissOlder than dirtCommented:
I restricted the floating combobox to the Type column and removed grngLinkedCell.
Q-28619595a.xlsm
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
haradaindustryofamericaAuthor Commented:
Perfect!  Thanks Martin!
0
 
Martin LissOlder than dirtCommented:
You won't forget to close this question I hope,
0
 
haradaindustryofamericaAuthor Commented:
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
 
Martin LissOlder than dirtCommented:
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
 
haradaindustryofamericaAuthor Commented:
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
 
Martin LissOlder than dirtCommented:
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
 
Martin LissOlder than dirtCommented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now