Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() http://www.gssitaly.com/IMPORT.ZIP In this wbook are present 2 sheets SOURCE and TARGET, and a button named IMPORT. Into column of SOURCE column C and E are present variuos value(Are similar an index, for me). My problem is: If i press on the button IMPORT show msgbox with 2 other buton "FROM CODE" or "FROM AGENCY". OPTION FOR CODE ============== If i click on "FROM CODE" active a userform named "SELECT FROM CODE". Show into this userform "SELECT FROM CODE" the list of value (without duplicate) into column E of sheet SOURCE. If i click, for example, on code "01" into a list of userform "SELECT FROM CODE", import all record from SOURCE indetify with code "01" and insert into sheet TARGET. OPTION FOR AGENCY ============== If i click on "FROM AGENCY" active a userform named "SELECT FROM AGENCY". Show into this userform "SELECT FROM AGENCY" the list of value (without duplicate) into column C of sheet SOURCE. Note: in this case show into userform only the first 4 cahracter on lleft from column C; for example "4500", "4501"... ecc.. If i click, for example, on code "4501" into a list of userform "SELECT FROM AGENCY", import all record from SOURCE indetify with code "4501" and insert into sheet TARGET. ... *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
average Line created in an existing line graph- based on one cell | Charts and Charting in Excel | |||
What event to detect click on UserForm ListBox? | Excel Programming | |||
UserForm TextBoxes (with ControlSource set) won't clear in one click | Excel Programming | |||
Click on worksheet with UserForm open? | Excel Programming | |||
select row in userform listbox with right-click? | Excel Programming |