Results 1 to 16 of 16

Question regarding adding a special keyboard symbol in a vba drop down list

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Excel 2021
    Posts
    974

    Question regarding adding a special keyboard symbol in a vba drop down list

    Hello,

    I'm currently using the following type of vba coding for a drop down list:
     'Set validation for Colums "c" to "Ag"
         With ws.Columns.Range("c5:Ag41").Validation
         
            .Delete
    .Add xlValidateList, xlValidAlertStop, xlBetween, "JF,BS,8F,DO,XX,X,4xx/4TR,4TR/xx,8H,7.5H,4H/XX,4v"
    
              
             With Selection
            .HorizontalAlignment = xlCenter
            .VerticalAlignment = xlBottom
            .WrapText = False
            .Orientation = 0
            .AddIndent = False
            .IndentLevel = 0
            .ShrinkToFit = True
            .ReadingOrder = xlContext
            .MergeCells = False
        
        End With
    What I'm trying to accomplish is to be able to insert a keyboard symbol (alt, 31) in front of "4V" at the end of the drop down list identified above. I'd also like to add another symbol (alt, 30) in front of another "4V", which I'd have to add to my drop down list. So the end product with symbols would look like ▲4v and ▼4v. If I try to paste this into the visual basic window I get the following: ?4v

    Any assistance would be greatly appreciated if this is even possible.
    Last edited by lilsnoop; 10-25-2013 at 05:28 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 05-30-2011, 09:29 PM
  2. Keyboard short cut for Paste Special > Text
    By Sepia in forum Excel General
    Replies: 2
    Last Post: 02-29-2008, 09:39 AM
  3. keyboard shortcut for paste special
    By Andrea in forum Excel General
    Replies: 2
    Last Post: 02-22-2006, 11:45 AM
  4. Keyboard shortcuts-Paste Special
    By Scott in forum Excel General
    Replies: 2
    Last Post: 01-25-2006, 12:55 AM
  5. Using a validation list drop down box with keyboard only
    By Peter Rooney in forum Excel General
    Replies: 3
    Last Post: 06-21-2005, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1