RE: [ExcelVBA] Re: LISTBOX

 

Thanks this will help bog time!
-----Original Message-----
Date: Wednesday, February 29, 2012 7:38:14 am
To: ExcelVBA@yahoogroups.com
From: "Ralph" <ralph.gregory@skaino.co.uk>
Subject: [ExcelVBA] Re: LISTBOX

Hi Derek I am trying to follow this and am a bit lost as to where I put the code...I created a new workbook and renamed a sheet Gages then put some data in etc then I created a user form with a listbox on it but now where does your code go and how do I run it....sorry if these are dumb questions but it is still a new world to me....

--- In ExcelVBA@yahoogroups.com, Derek Turner <g4swy@...> wrote:
>
> Hi All
>
> Here is my own code to do what Jim wants :- 
>
>
> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
> '   Populate a multicolumn Listbox (with >10 columns) from an Excel range
> '   Derek Turner February 2012
> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
> Private Sub UserForm_Initialize()
> Const FIND_I = "MPR0010"
> Const FIND_J = "T1"
> Const COLUMN_I = 9
> Const COLUMN_J = 10
> Const LISTBOXCOLUMNS = 17
> Const TITLEROW = 1
>
> Dim vSourceArray As Variant, vSubsetArray()

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (16)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___