Results 1 to 7 of 7

Comparing a value of concantenation of strings against a string

Threaded View

  1. #1
    Registered User
    Join Date
    05-19-2017
    Location
    Minnesota
    MS-Off Ver
    2013
    Posts
    4

    Comparing a value of concantenation of strings against a string

    I am trying to compare the value of the concantenation of the port_val variable without quotes so it reads similar: s_1_0_2.value . This so happens to be an objectname in the userform:

    Function forty_eight_port()
    'Populate data for 48 Port Switch:'
    interface = 1
    
    port_count = 48
    For p = 1 To port_count
    
    port_val = "s" & stack & "_0_" & interface & ".value"
    vlan_val = "vlan" & stack & "_0_" & interface & ".value"
    If port_val = "Business" Then
    portslot = portslot + 1
    Range("D" & portslot) = vlan_val & ", 201"
    Range("E" & portslot) = "User/Phone"
    ElseIf port_val = "Process" Then
    Range("D" & portslot) = vlan_val
    Range("E" & portslot) = "Reserved for Process"
    ElseIf port_val = "Access Point" Then
    flex_val = "flex" & stack & "_0_" & interface & ".value"
        If flex_val = "False" Then
        Range("D" & portslot) = "105"
        Range("E" & portslot) = "Reserved for AP"
        Else
        Range("D" & portslot) = "105,282-287"
        Range("E" & portslot) = "Reserved for FlexAP"
        End If
    End If
    interface = interface + 1
    Next p
    End Function
    Any ideas?
    Last edited by seph2004; 05-19-2017 at 05:13 PM. Reason: Moderation request fulfillment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Looking for a SUM UNTIL solution
    By pmguerra in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-13-2017, 05:19 AM
  2. Looking for a sumproduct solution or any other possible solution
    By akliot in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-29-2015, 11:42 AM
  3. Is 'ranking by' a VBA solution or a manual solution?
    By mtw2018 in forum Excel General
    Replies: 2
    Last Post: 04-10-2012, 01:47 PM
  4. N/A to 0 Solution
    By CraigyBoy in forum Excel General
    Replies: 8
    Last Post: 02-10-2011, 04:06 AM
  5. NA Solution
    By bear in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-28-2007, 02:03 AM
  6. Best solution VBA/C++
    By Charles in forum Excel General
    Replies: 3
    Last Post: 08-02-2006, 01:00 PM
  7. Vba Help With A Solution
    By RELWOD85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2005, 02: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