Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Copy line based a click into userform...


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
average Line created in an existing line graph- based on one cell Melanie Charts and Charting in Excel 2 December 27th 07 09:14 PM
What event to detect click on UserForm ListBox? Don Wiss Excel Programming 1 August 26th 05 10:35 PM
UserForm TextBoxes (with ControlSource set) won't clear in one click Paul Martin Excel Programming 2 March 17th 05 11:55 AM
Click on worksheet with UserForm open? Ed[_23_] Excel Programming 5 September 2nd 04 11:38 PM
select row in userform listbox with right-click? RB Smissaert Excel Programming 3 August 17th 04 05:49 PM


All times are GMT +1. The time now is 12:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"