Search:

Type: Posts; User: qiqinuinaifen128

Page 1 of 4 1 2 3 4

Search: Search took 0.04 seconds.

  1. Re: [ExcelVBA]Calling macro in different workbook

    anyone can help me with this or suggestion would be appreciated
  2. [ExcelVBA]Calling macro in different workbook

    Hi, I have a two workbooks (workbookA and workbookB). I am trying to call the macro workbookA's macro from workbookB. (The macro in the workbookA is actually doing the filtering workbookA data)

    I...
  3. Re: [Excel VBA]Filtering Data from Excel Sheet

    Thank for your help. I've solve it. Below are the code that i use it for filtering year, month and day.



    If TWOFIVEOB.Value = True Then _
    .AutoFilter Field:=13,...
  4. Re: [RESOLVED] Office20007 (Excel) Filtering Data from excelsheet on the Userform

    I face one of the problem which i don't know how to write a function that can filtering the date. i have a column that recorded the Date of Birth of Client.

    I want to create a function that filter...
  5. Re: [Excel VBA]Filtering Data from Excel Sheet

    Any advice would be appreciated?

    i thought of using the formula =right(E3,4) to get the last four digit from the DOB. But the problem is the DOB column format is Date, even i use the formula...
  6. [RESOLVED] [Excel VBA]Filtering Data from Excel Sheet

    Hi,

    I have a excel data which is looking like the attachment image.

    I want to add one function into the userform which can let the user to select and filtering the date according the age....
  7. Re: Office 2007 Excel Vba - Dynamic UserForm

    Do you think should i create four different frames in order to have different number of selections inside the frame?

    East, West, South, i have four places to choose and North i only have 2 places...
  8. Re: Office 2007 Excel Vba - Dynamic UserForm

    Select Case Location
    Case Is = "East"
    OptionButton7.Caption = "Hongkong"
    OptionButton8.Caption = "China"
    OptionButton9.Caption = "Japan"
    ...
  9. Re: Office 2007 Excel Vba - Dynamic UserForm

    I will try the file that you sent to me. Thanks :)
  10. Re: Office 2007 Excel Vba - Dynamic UserForm

    Or do you think if it is better to have a userform which have 4 buttons to call the different userform for (E, S, W, N)?
  11. Re: Office 2007 Excel Vba - Dynamic UserForm

    I wish I can show it at the same userform. When the (e,s,w,n) is selected. Can you roughtly show me the code?
  12. Re: Office 2007 Excel Vba - Dynamic UserForm

    Any advise or suggest for this would be appreciated
  13. Re: Office 2007 Excel Vba - Dynamic UserForm

    Hi, thanks for your reply. I store my lists (Country) in the four different sheet (East, South, West North)
  14. Office 2007 Excel Vba - Dynamic UserForm

    Hi,

    I would like to check if there are any dynamic userform for excel 2007?

    Current i have four different worksheet (East, South, West North) which contain client information. I have a userform...
  15. Re: Office20007 (Excel) Filtering Data from excelsheet on the Userform

    Message is noted.

    Currently i am working on the project applying all those code that you share with me. I wish i could make it more user friendly. I may need help anytime cause i am very...
  16. Re: Office20007 (Excel) Filtering Data from excelsheet on the Userform

    Thanks brother :)
    It solve the problem. Awesome!
  17. Re: Office20007 (Excel) Filtering Data from excelsheet on the Userform

    Hi,

    You are right the option button issue. But after i have corrected it.
    Since i am using the Radio Button on selecting worksheet and Gentle.
    If i select the gentle, it will not select the...
  18. Re: Office20007 (Excel) Filtering Data from excelsheet on the Userform

    Hi, the previous mistake was fix :)
  19. Re: Office20007 (Excel) Filtering Data from excelsheet on the Userform

    I just found another error when i use the radio button of (Male, Female)
    Subscript Out of Range
  20. Re: Office20007 (Excel) Filtering Data from excelsheet on the Userform

    I am using your below code. It work okay for selecting the different worksheet. But for the FilterName, I got below compile error (Variable Not Define).
  21. Re: Office20007 (Excel) Filtering Data from excelsheet on the Userform

    Hi,

    I have another question, If i have four set of data Sheet A, B, C, D
    which i want to let the user to choose which worksheet they want to work with.
    Can you advice with the code?
    By the way,...
  22. Re: Office20007 (Excel) Filtering Data from excelsheet on the Userform

    Awesome! :P

    if i would like to add another button (FilterName), to filter the data in the TextBox1 to TextBox1.

    The Button(FilterName) function is to filter all the words and whitespace and...
  23. Re: Office20007 (Excel) Filtering Data from excelsheet on the Userform

    Wow. It is exactly want i want. Thank you so much.

    If i would like to add another factor to filter the data,
    for example.Gentle (Male/Female)

    Should i use checkbox or radio button?
    (I would...
  24. Re: Office20007 (Excel) Filtering Data from excelsheet on the Userform

    Thank you so much. Yes it is what i want, can i display the contact number beside the Name?
  25. Re: Office20007 (Excel) Filtering Data from excelsheet on the Userform

    Thank you so much for your prompt reply.

    I have create a data and kindly refer to the attachment.
    (By the way, i have change the product to subject.

    Really appreciate it!
  26. [RESOLVED] Office20007 (Excel) Filtering Data from excelsheet on the Userform

    Hi,

    I have an excel data and below is how the excel data look like

    Name Contact Product1 Product2 Product3 Product4 Product 5 product6
    ABC 12345678 Iphone Ipad Imac Nil Nil Nil
    CBE 23456789...
  27. Replies
    81
    Views
    5,139

    Poll: Re: Genuine or Fake

    There are many disasters in recently, flooding, hurricanes, typhoons, earthquake, tornados, heat waves, and droughts:(...Global warming sign or the end of the world:wave:
  28. Long time never touch programming

    Wow, long time never back to this forum....

    Missing the time when I'm doing my project doing my study time....

    Never use programing for such a long time.....

    Don't know how to start it...
  29. Replies
    8
    Views
    739

    Re: [RESOLVED] Php

    Hi,

    Thank you so much for your help. I finally get there.
  30. Form Help : Handle Chinese Character

    Hi Pros,

    I have a question regarding handling chinese character.

    I have an text area for user to key in sth. But when the user key in Chinese Character and click a button[this button is for the...
  31. Replies
    8
    Views
    739

    Re: [RESOLVED] Php

    I am not strong in php. Don't know how to turn it off and where should i add the code similar to you provide to me. Really appreciate it.

    People said that save php.ini into cgi-bin. But i don't...
  32. Replies
    0
    Views
    753

    Java Script - Form input text

    Hi,

    I have some questions regarding the javescript

    I have a form and there are several text box for user input text.

    Is it possible to use javascript to control the input? What i want is...
  33. Replies
    8
    Views
    739

    Re: Php

    Thank you for you reply. It 's work

    Here is the code for references



    <?php
    // Check for user data, if its not empty do this...
    if ( !empty( $_POST['FileContent'] ) )
    {
  34. Replies
    8
    Views
    739

    Re: Php

    Yup, i don't why now i can choose the path and change the name. Thanks

    I have a another question
    i have an textarea for user to key in and a button for user to save what they key in into the...
  35. Replies
    8
    Views
    739

    [RESOLVED] Php

    Hi,

    I'm a beginner of php. I am using below php code to save what is inside the testarea, but when i press the button of 'save thank you page' , it's only prompt a window for me to "save" not...
  36. Replies
    1
    Views
    462

    Microsoft Access

    Dear Pros,

    I have a question about Microsoft Access.
    Currently i have a simple Access datebase for my client. The database contain all my customer particulars. Every time if thare is new customer...
  37. Replies
    3
    Views
    717

    Re: Convert c++ code to C

    I admit my standard is very extreme beginners. I know you are pro, If you don't want to offering help, please don't give so much of advise. I am here to seek for solution not seek for advise from...
  38. Re: how to check whether the string is number?

    May be you are right. But how long you learn a language?
  39. Replies
    3
    Views
    717

    Convert c++ code to C

    Is anybody know how to convert below the code to c
    [Code]
    #include <iostream>
    #include <limits>

    using namespace std;

    int main() {
    int number = 0;
    cout << "Enter an integer: ";
  40. Re: how to check whether the string is number?

    i really dont know how to use the command into my program.
Results 1 to 40 of 144
Page 1 of 4 1 2 3 4



Click Here to Expand Forum to Full Width