Results 1 to 6 of 6

add drop down box's to multipul cells in the same sheet

Threaded View

  1. #1
    Registered User
    Join Date
    07-02-2018
    Location
    australia
    MS-Off Ver
    2016
    Posts
    60

    add drop down box's to multipul cells in the same sheet

    Good afternoon
    I'm trying to add drop down box's to different cells on the same sheet
    Sub DropDownListinVBA()
    Range("A2").Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
    Formula1:="VIPER CLASS A,VIPER CLASS B,VIPER PHANTOM"
    
    End If
    
    Range("C2").Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
    Formula1:="TROY,PETER,KAYLA"
    End Sub
    Last edited by danny25; 01-28-2022 at 07:37 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How extract values from multipul sheet
    By keshavtale in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2019, 01:51 PM
  2. [SOLVED] Lookup values in multipul sheets and show value in another sheet
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 06:05 AM
  3. [SOLVED] Lookup values in multipul sheets and show value in another sheet
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 04:05 AM
  4. Lookup values in multipul sheets and show value in another sheet
    By Kim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. Lookup values in multipul sheets and show value in another sheet
    By Kim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. Lookup values in multipul sheets and show value in another sheet
    By Kim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. Lookup values in multipul sheets and show value in another sheet
    By Kim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

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