Results 1 to 1 of 1

Thread: CMD btn create new workbook depends upon multiple comboboxvalues

  1. #1

    CMD btn create new workbook depends upon multiple comboboxvalues



    Register for a FREE account, and/
    or Log in to avoid these ads!

    DEAR EXPERTS
    EXTREME MACRO FUNCTION

    I WANT CREATE WORKBOOK DEPENDS UPON VALUE OF COMBOBOX.
    I HAVE SET OF DATA RANGE FROM (A:BT) THROUGH COMBOBOX VALUES IN USERFORM I WANT CREATE SEPARATE WORKBOOK WITH THE WORKBOOK NAME OF SELECTION TWO VALUES(COBOBOX BOX 4 AND 6 SELECTION VALUE).XLS



    SEE EXAMPLE
    COMBOX1 IF REGION IS WEST THEN COMBOX 2IF PARTNERNAME IS Emall(ecs) COMBOX3 IF PARTS IS ZLAB COMBOX4 IF PROD TYPE IS IDEA COMBOX5 IF PARTS DELIVERED IS "N" COMBOX6 IF RESPONSIBILITY IS "SHALINI"

    ( RESULT SET OF 10 DATA ) WITH WORKBOOK NAME OF (IDEA_SHALINI.XLS) COMBOVALUE(4&6) WILL BE SHEET NAME
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •