I am now attempting to build a user form to polish my
project off but
have not had any experience with them and so need some help
if
possible please.
In the original spreadsheet there are three synchronised
drop down lists
(Element - SubElement - Attribute)which utilise this code.
Private Sub cbElement_Change()
cbSubElement.RowSource =
Range(cbElement.RowSource).Cells(cbElement.ListIndex + 1, 1)
End Sub
In the user form the drop downs are called cbElement -
cbSubElement - cbAttribute.
They work very well in the spreadsheet but I am not sure of
how to make
them work in the user form?.
TIA
John R Spain
Asset Management Service
5th Floor
Civic Offices
Guildhall Square
Portsmouth
********
************************************************************
**
This email is for the intended recipient only.
If an addressing, transmission or other error
has misdirected this email, please notify the
author by replying to this email.
If you are not the intended recipient you must
not use, disclose, distribute, copy or print it.
This email may be monitored, read, recorded
and/or retained by Portsmouth City Council.
Email monitoring/blocking software may be used.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|