Search:

Type: Posts; User: lok1234

Page 1 of 7 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    3
    Views
    818

    MsOf13 Re: [Excel VBA] Enum question

    Many thanks. There would be around 5 to 6 products. I could not use database as it is just an desktop application for sales.

    Actually, can I "pass" the enum from each product worksheet to...
  2. Replies
    3
    Views
    818

    MsOf13 [Excel VBA] Enum question

    Hi all,

    I have been asked to enhance an existing Excel application by my boss. This existing Excel application has a module called mdlCalcFee. Inside this module, there is an enum declaration as ...
  3. MsOf10 Re: [Excel] VBA for hide all columns except a specific named range

    This also work, thank you.
  4. MsOf10 [RESOLVED] [Excel] VBA for hide all columns except a specific named range

    Hi all,

    i have a worksheet A, it has a button and a pull down menu there. The pull down menu stored a list of named range name. Also, I have worksheet B with lots of named range there.

    When...
  5. MsOf10 Re: [Excel] VBA for summing up one column based on the unique value in another column

    Many thanks, all guys! I got the solution
  6. MsOf10 Re: [Excel] VBA for summing up one column based on the unique value in another column

    Many thanks for your help. May I know what the meaning of this code behind? CountIf(cel.Offset(-cel.Row + 1).Resize(cel.Row), cel)
  7. MsOf10 [RESOLVED] [Excel] VBA for summing up one column based on the unique value in another column

    Dear all,

    I have the following data in a worksheet

    Col A Col B

    Country Total
    UK 100
    USA 200
    HK 300
  8. Replies
    0
    Views
    2,253

    [Urgent] Excel Pivot Table Question

    Dear all,

    Background:
    I have a Table as below:

    133063

    Basically, this table shows the status of the employees of a company from Dec-15 to Mar-16.

    Pivot Table Result:
  9. [RESOLVED] [Excel 2003] How to display the cell value only instead of formula

    Dear all,

    I am currently using Excel 2003. One of my worksheet has so many complex cell formulas which makes the excel response slow when i open/close/save the workbook, therefore, I place a...
  10. Replies
    0
    Views
    1,880

    [HTML] How to operate an Excel file in HTML?

    Dear all,

    I just have written a very simple Excel so that users can operate (update/insert data) it.

    I don't want to put it in a "share driver". Instead, I want to put it in a web site so that...
  11. Re: loop the data and display in label

    Many thanks, Is there any code sample? :blush:
  12. [RESOLVED] loop the data and display in label

    Dear all,

    I am writing a lucky draw system.

    when user presses the "Start" button, all the participant names will be looped and displayed fastly in a label until the user press "stop" button,...
  13. Re: [Help] str()makes 0.123 become .123

    thanks, this is what i want. :wave:
    i dont know there is a cstr().

    what is the difference between str() and cstr() :wave:
  14. [RESOLVED] [Help] str()makes 0.123 become .123

    Dear all,

    I have a function to handle a value parameter:

    Function f_dec2str(p_Value)
    Debug.Print p_Value
    Debug.Print Len(p_Value)
    Debug.Print...
  15. Re: [Help] 1556.437 - 1556.245 = 0.192000000000007

    Many thanks for your comment :thumb:
    One of my concern is, it is possible for price_difference to have up to 7 d.p.
    So, is there any other datatype that can support 7 d.p.?
  16. Re: [Help] 1556.437 - 1556.245 = 0.192000000000007

    Many thanks for all of your reply. :wave: Since I don't have the database on hand now, so, I can not show you the sample data at that moment :o

    can I code it in this way to avoid the error (as I...
  17. [Help] 1556.437 - 1556.245 = 0.192000000000007

    Dear all,

    I have a table called "Price" in Access Database.

    And I use the following codes to calculate the Price Difference.
    (I extract part of the codes here)


    Dim aRs As New...
  18. Re: where should I put the library files (.OCX) ?

    thank for your information.

    One question, in case the six OCX files are placed in common share folder, will the exe "read" the six OCX files in this common folder instead of users' local PC...
  19. Replies
    14
    Views
    1,310

    how to random generate date and time?

    Dear all,

    Is there any function that i can use to random generate date and time?

    Say, I pass "23-June-2010" and "09:00 to 18:00" as the parameters, the function will ouput a datetime within...
  20. where should I put the library files (.OCX) ?

    Dear all,

    I have six OCX files need to be used in my project, they are:

    MSCOMCT2.OCX
    MSDATGRD.OCX
    MSFLXGRD.OCX
    tabctl32.ocx
    MSHFLXGD.OCX
    MSCOMCTL.OCX
  21. Re: How to know which column in Listview is being right-click?

    prefect solution. thanks a lot
  22. [RESOLVED] How to know which column in Listview is being right-click?

    Dear all,

    I have a Listview. There are 5 columns in this Listview. How can I know which column in the listview is being right click?

    For example, the user click the right button of mouse...
  23. Re: is it possible that textbox can display "tips" when user input a keyword?

    i see, many thanks. That means, i should restrict the content in the combo box instead of using coding. :)
  24. Re: is it possible that textbox can display "tips" when user input a keyword?

    this is great, many thanks :thumb:

    but, in case, i have an item in the combo box, say "David Beckham". If user enter "Beck", how to make the "instr" can search this item?
    :wave:
  25. [RESOLVED] is it possible that textbox can display "tips" when user input a keyword?

    Dear all,

    I want to code a textbox which behave like "google" searching (as in the graph below). When user input a keyword in a textbox, say, "visual bas", it will display all relavant records in...
  26. Re: Append text to a text file in "desc" order

    hey, guys, thank you so much, without ur help, i cannot say in programmer position, thanks:wave::thumb:
  27. Re: Append text to a text file in "desc" order

    thank you again. :wave:
    a side track question:


    Open App.Path & "\test.txt" For Input As #FF
    strFile = Input(LOF(FF), FF)
    Close #FF

    can I start the reading of the test.txt file in the...
  28. Re: Append text to a text file in "desc" order

    thank you :wave:
    is the disadvantage related to "consume memory" and "slow performance" if the file is large in size?
  29. [RESOLVED] Append text to a text file in "desc" order

    Dear all,

    I use the code below to append text to a text file:


    Open "c:\abc.txt" for Append as #1

    If I want the appending to be "last in, but on the top of the text file", how?
    ...
  30. Replies
    11
    Views
    1,164

    Re: can timer start at 0 seconds?

    thank you a lot for all of your input. I have learned from you all. :)
  31. Replies
    11
    Views
    1,164

    Re: can timer start at 0 seconds?

    Hi, i suppose your "inside timer1" means "Private Sub Timer1_Timer()"

    If this is what you mean, then, your code could not make the label refresh the time every second. It will permanently display...
  32. Replies
    11
    Views
    1,164

    [RESOLVED] can timer start at 0 seconds?

    Timer1.Interval = 1000 '~~~> 1 second
    Timer1.Enabled = True


    Private Sub Timer1_Timer()
    lblTimer.Caption = Time '~~~> Display the time in Labelbox
    End Sub

    The above code make the...
  33. Replies
    27
    Views
    10,015

    Re: can I embed a BAT file into a VB Form

    Hi, many thanks for your reply :wave:

    Your suggestion is working fine, but in case,

    the command prompt is waiting for user's response (e.g. prompt options for user to choose), but the user...
  34. Replies
    27
    Views
    10,015

    Re: can I embed a BAT file into a VB Form

    hi,
    i tried to implement the shellpipe user control into my project. What I have found is, there is "cmd.exe" in the task manager which cannot be killed when i terminate the project. This happens...
  35. is it possible to select rows in mshflexgrid using the ctrl key?

    is it possible to select rows in mshflexgrid using the ctrl key and is there any function returning the selected rows?

    ie.
    user can select
    row1
    row3
    row7

    function return which rows are...
  36. Re: Questions about user-defined [Type] and [ComboBox]

    Thank you for the comment from both of you. It really helped me a lot. :wave:
  37. Re: Questions about user-defined [Type] and [ComboBox]

    thank you:wave:

    in case the dept_id is string, how to deal with it?
  38. [RESOLVED] Questions about user-defined [Type] and [ComboBox]

    Dear all,

    I have the following "type" defined and when form is loaded, datas are loaded into the types:



    Public Type typDept
    Dept_ID As String
    Dept_Name As String
    ...
  39. Replies
    27
    Views
    10,015

    Re: can I embed a BAT file into a VB Form

    haha, yes, the spCMD is picturebox after I move the form to my project. Therefore, it is just copy and paste error. Many thanks for your kind help :wave:
  40. Replies
    27
    Views
    10,015

    Re: can I embed a BAT file into a VB Form

    hi,
    I have added the user controls (shellpipe.ctl) and smartbuffer.cls into my project, and also, copy the file shellpipe.ctx into my project folder. When I compile the program, it says:

    "Method...
Results 1 to 40 of 259
Page 1 of 7 1 2 3 4



Click Here to Expand Forum to Full Width