Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by vbcoder2012

  1. vbcoder2012

    Change References to Type Library

    I have the same problem, although mine is with shockwave flash. Since it is version specific, my model gives an error to all users who have upgraded their software.
  2. vbcoder2012

    Remove Shockwave from Reference library

    I have a vb program (VB 6) and i want to remove shockwave flash from the reference library, because it is creating problems in compiling the code. So i have removed all of the shockwave code that i had in my vb code, and i went on tools- references, and tried to uncheck "shockwaveFlash". But i...
  3. vbcoder2012

    Array Value not coming out in the Text Box

    This is the code i have, i cant provide all the code, its just to big to fit here...but these are parts. So you see, i'm trying to get the value of USA in City, that should come out in the textbox, but all i get is "hello". where as in the excel cell i get "Hello Fortworth". What can the...
  4. vbcoder2012

    Passing Array value in textbox. The textbox turns up empty.

    This is the code i have, i cant provide all the code, its just to big to fit here...but these are parts. So you see, i'm trying to get the value of USA in City, that should come out in the textbox, but all i get is "hello". where as in the excel cell i get "Hello Fortworth". What can the...
  5. vbcoder2012

    Passing Array value in textbox. The textbox turns up empty.

    Public Function UT(Segment, Bandwidth, P_Lline, Mult, USA) Dim r1 As Range, r2 As Range, r3 As Range, myMultiAreaRange As Range Worksheets("NP").Activate Selection.AutoFilter Set r1 = Range("a1:a50000") Set r2 = Range("j1:j50000") Set r3 = Range("s1:s50000") Set myMultiAreaRange = Union(r1, r2...
  6. vbcoder2012

    Passing Array value in textbox. The textbox turns up empty.

    JoeatWork", Even if i switch places, and write Pline(9) first and then test, USA = Pline(9) & test City = USA the excel cell shows "Fortworth Hello", but in the textbox, i still get "Hello" USA = test & Pline(9) City = USA So thats how i know that the value is not coming out in the...
  7. vbcoder2012

    Passing Array value in textbox. The textbox turns up empty.

    Hi all, Pline(9) is an array with 10 elements, and every element is allocated a value Pline(1) = "the" & routingsegment . . . Pline(9) = USCityA My problem is that when i allocate this Pline(9) = USCityA test = "Hello" USA = test & Pline(9) City = USA then i only get "Hello" in the...
  8. vbcoder2012

    Passing Array value in textbox. The textbox turns up empty.

    I am passing the value of an array to a textbox, but it always turns up empty. When i pass the same value to an excel cell, i get the value. The function calculates the value of USCityA I am giving parts of the code below: Redim Pline(9) Pline(9) = USCityA test = "Hello" USA = test & Pline(9)...

Part and Inventory Search

Back
Top