Posts by Sathia.N.G.

    Need formula to calculate total units for one hour.


    [TABLE="width: 396"]

    [tr]


    [td]

    Min Per hour

    [/td]


    [td]

    Process time

    [/td]


    [td]

    Wafers

    [/td]


    [td]

    Unit Per Hour

    [/td]


    [/tr]


    [tr]


    [td]

    60

    [/td]


    [td]

    0:36:00

    [/td]


    [td]

    25

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    60

    [/td]


    [td]

    0:15:00

    [/td]


    [td]

    25

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    60

    [/td]


    [td]

    1:00:00

    [/td]


    [td]

    25

    [/td]


    [/tr]


    [/TABLE]

    Re: Need to apply same condition of userform in different page of sheet.


    Hi Pike,
    Thanks for code adjustment.
    I just did a bit changes at above code.
    Since it's already has been declare the 1st Item as Page Number 1,
    It was repeat the Page Number 1 for 2nd page with 2nd page range value and so on...
    I just added:-

    Code
    1. Me.ComboBox3.AddItem "Page Number " & intpages + 1 & " - Start:=" & Range("A" & objPBreak.Location.Row + 4).Value


    Thanks yar...


    FYI, I am trying to change the Commandbutton into 'Shapes' with assign Macro as button,
    It's still re-size and move left top, but once click the column 'D', which is with conditional formatting,
    the button back to original.
    From this scenario, whether you have any idea the error cause.


    Thanks again.

    Re: Need to apply same condition of userform in different page of sheet.


    Hi,
    I am not sure about Print view...:question:
    Using 'Microsoft Office Professional Plus 2010 - Microsoft Excel 2010'.


    Can I little adjustment an above code again.
    Which is, I need to show 'value' rather than the 'Raw number'.
    Something like Range("A5", "A88", "A171","A254") value & Page number
    Example : "AAA1234.1 - at Page number 1".
    "AAA1234.2 - at Page number 2".
    "AAA1234.3 - at Page number 3".
    and so on....

    Re: Need to apply same condition of userform in different page of sheet.


    Hi,
    It's not only 4 pages. Its possible 1 or more.
    I haven't test for commandbutto3 range array with single and multi pages,
    because engage to find solution for the commandbutton1 resized and moved issue. Can help to re-code userform initialize section and if can for the commandbutton1 issue too.


    Thank you very much.

    Re: Need to apply same condition of userform in different page of sheet.


    Hi
    I am trying to adjust/add some additional information at userform_initialize.
    But it's not work as required.


    Actually, I want to add particular page number at after every range value.


    Can anyone to adjusted it...

    Re: Need to apply same condition of userform in different page of sheet.


    It is the same attachment that Mr.Pike posted at thread #6.
    Previous post attachments are not affected.
    and for the 2nd question, that is request for replaced value at ComboBox3, I believe it wouldn't work for 'Header',
    because of it will be same value at all the pages. So I prefer to capture value from A5, A88, [B]A171 and [B]A254.


    Thank you guys...[/B][/B]

    Re: Need to apply same condition of userform in different page of sheet.


    [ATTACH=CONFIG]67266[/ATTACH]
    [ATTACH=CONFIG]67267[/ATTACH]
    Hi,
    Above picture was print screen of the error.
    Every times after click the "Lot Rework Activity"and the "verification" button,
    "Lot Rework Activity" button was reduce/smaller the size and keep moving left.


    Please help on this error....


    And one more request, that there is a possible to capture or choose the value from four selection, which is A5, A88, [B]A171 and [B]A254,
    [/B][/B]rather than Page numbers or at least choose the[B][B] 'Header'[/B][/B], at ComboBox3?

    Re: Need to apply same condition of userform in different page of sheet.


    Hi Pike,
    I am trying to edit at...


    And there are another error, that once click the commandbutton1 at page 1, it's auto move to left and smaller the size, after click.
    when keep click it's keep moving and keep small the size.
    Even value selected at for another pages from page 1, but textbox value remain update input at page 1.

    Re: Need to apply same condition of userform in different page of sheet.


    Above statement was not so clear...


    Please refer to this attachment:- ozgrid.com/forum/core/index.php?attachment/67211/


    Currently, ComboBox1 and ComboBox2 are to select all the down at column 'B'.
    I want to split it within some range with another additional selection of ComboBox3.
    (Please refer in 'Page Layout' for more clear picture that I split by 4 pages)


    My requirements are as below:-
    ComboBox3 to choose value from four selection, which is A5, A88, A171 and A254.
    When select A5, ComboBox1 and ComboBox2 will only capable for selection of B5 to B82. (which is Page1)
    When select A88, ComboBox1 and ComboBox2 will only capable for selection of B88 to B165. (which is Page1)
    When select A171, ComboBox1 and ComboBox2 will only capable for selection of B171 to B248. (which is Page1)
    When select A254, ComboBox1 and ComboBox2 will only capable for selection of B254 to B331. (which is Page1)


    (Note: Currently I copy CommandButton1 for all the pages, but only 1st page button should be active)

    Hi
    Need adjustment/modification help...
    In page #1 have an condition as attached file.
    Previously I used as normal page & the userform is coded for whole pages.
    But now I have to split another 3 pages whenever there is different situation needs.
    Same requirements are apply to all the pages.


    I want combobox1 and combobox2 are only allowed to get data for particular pages.


    Please help...
    [ATTACH=CONFIG]67206[/ATTACH]