Search:

Type: Posts; User: skparkcn

Search: Search took 0.03 seconds.

  1. Replies
    9
    Views
    1,404

    Re: Compile error on compiling array copy sub

    If it is, no way.
    Thank you for your reply, westconn1.
  2. Replies
    9
    Views
    1,404

    Re: Compile error on compiling array copy sub

    Happy new year!

    I could not fully understand and decided to try class module instead of array. I coded three class modules, two of which is referred by higher class module.

    Class module clsItem...
  3. Replies
    9
    Views
    1,404

    Re: Compile error on compiling array copy sub

    Dear westconn1

    Do you mean the parameter of Sub CopyArray cannot be declared as variant? Then, I cannot understand why this kind of open code declaring as varint is on internet? Please consider...
  4. Replies
    9
    Views
    1,404

    Re: Compile error on compiling array copy sub

    Dear Steve,

    Thank you for your reply.

    I am using Korean version. If I translate the error message to English, it means "only user-defined type defined in Public object module can be...
  5. Replies
    9
    Views
    1,404

    Compile error on compiling array copy sub

    Dear everyone

    I have coded a sub in one module as followed:


    Public Type StockRecordType
    SheetID As String
    SupplierID As Long
    IPrice As Double
    Qty As Long
  6. MsOf07 Re: Refresh of Active X label values before printing

    I misunderstood that I included Active X LABELs as the part of the invoice. Actually I included Active X TEXTBOXes except one and defined as below:


    Set ctrlSheetSheetID =...
  7. MsOf07 Re: Refresh of Active X label values before printing

    Thank you for your comments.

    vbfbryce, I am sorry my code is too big to cut and paste to here.

    I tried TnTinMN and westconn1's suggestions. But, I am not fully understand that, if I insert...
  8. MsOf07 [RESOLVED] Refresh of Active X label values before printing

    Dear everyone

    I have coded the function that batch print of several invoices of same form. The form is composed of the range of sheet cells and Active X labels. If I one click the button,...
  9. Replies
    3
    Views
    759

    MsOf07 Re: Correct scrolling limit

    Dear seenu_1st

    It is just scroll to destinated column, and my problem is still not solved. I suppose, because of this problem, my VBA code cannot be excused. If I copy the data to new sheet and...
  10. Replies
    3
    Views
    759

    MsOf07 Correct scrolling limit

    Dear Everyone,

    I have a worksheet having data to column AMR. When I make columns shown and hidden several time using VBA, the horizental scroll bar of Excel has a problem as followed:

    1. To see...
  11. MsOf07 Appropriate scrolling to end of data-containing cell

    Dear Everyone

    After I hide and show columns several times using VBA, if I drag horizental scroll bar to right-most position, my excel put the screen to empty cells that has no data and also never...
  12. MsOf07 intersect more than two incontinuous ranges

    Dear everyone

    I coded following:


    ReDim rngFound(LBound(Keywords)) As Range
    Set rngAllFound(LBound(Keywords)) = FindRanges(Keywords(LBound(Keywords)), rngAllRef, myxlRow)
    ...
  13. MsOf07 Re: Get sub-key names under a key in registry

    I solved my problem when I followed westconn1's recommendation.

    Thank you westconn1 and koolsid.
  14. Re: list all keys, subkeys and values in registry hive

    Dear westconn1

    I already solved my problem when I refer to your post above. I tried to post saying SOLVED but I just found it was not, right now.

    Thank you for your comment.
  15. Re: list all keys, subkeys and values in registry hive

    Dear westconn1

    I am writing this reply on your comment on my question about registry manipulation. I copied your code to my excel file and compiled it, but met an error on line 8 in Sub getvals....
  16. MsOf07 Re: Get sub-key names under a key in registry

    Dear koolsid

    I am sorry to late reply. I tried what you recommended to use in my code, but my Excel shut downed. I do not know why. There may be an error during transfer to my computer...
  17. MsOf07 [RESOLVED] Get sub-key names under a key in registry

    Dear Everyone

    I am learning manipulating way of Windows registry using VBA. I could find very useful modules and explanations for it, but I still never found the way for getting unknown sub-key...
  18. MsOf07 Re: Link an image on sheet to command button

    Dear westconn1

    Thank you for your hint. I've got the result with no more code correction from what you suggested!! The solution was just beside me.
  19. MsOf07 Re: Link an image on sheet to command button

    Dear westconn1

    It is not so clear, as I do not know the term exactly. However, I really thank you for your kind interest on my problem. I will continue to solve this problem.
  20. MsOf07 Re: Link an image on sheet to command button

    Dear westconn1

    I attached the workbook having problem. Because it is difficult for me to simplify the code, and I am afraid of making problem during simplification, I send it as it is.

    However,...
  21. MsOf07 Re: Link an image on sheet to command button

    I previously declared "wsQuiz" as followed:


    Set wsQuiz = Worksheet("Quiz")

    I do not know why, when I test it, it is OK, but, when totally changed it, run-time error occurred.
  22. MsOf07 Re: Link an image on sheet to command button

    Thank you for your kind reply.

    I coded as followed:


    Set frmStartQuiz.cmdQFwd.Picture = wsQuiz.Shapes("Arrow Grey Fwd").OLEFormat.Object.Object.Picture

    where frmStartQuiz is the...
  23. MsOf07 Re: Link an image on sheet to command button

    Dear westconn1

    Thank you for your kind answer. Your help solved my a week of trouble.
  24. MsOf07 Re: Link an image on sheet to command button

    At first, to display the image on the command button, I coded as followed:

    cmdFwd.Picture = LoadPicture("D:\Temp\ArrowFwd.bmp")

    However, for this, I always have to keep the image file present...
  25. MsOf07 Re: Link an image on sheet to command button

    Dear westconn1

    I am sorry that my explanation is not clear for your understanding.

    I want the picture is displayed on the command button. That is, I just want change displayed picture when...
  26. MsOf07 [RESOLVED] Link an image on sheet to command button

    Dear everyone,

    I am using MS-Excel 2007.

    I have an image (shape) on a sheet, named "ArrowFwd". I want make a command button(named "cmdFwd") showing "ArrowFwd" by using "cmdFwd.Picture". Excel...
  27. Re: Like Worksheets object in class module

    Thanks
  28. [RESOLVED] Like Worksheets object in class module

    Dear All,

    If I want make a new sheet, I may just make a code Worksheets.Add. And, if I want to access a worksheet among worksheets, I may just make a code Worksheets(1) or Worksheets(2). Likewise,...
  29. Re: Communication between class modules in Excel VBA

    Of course, I am using MS-Excel, not MS-Word. I hope your understandng that, because I am beginer of Excel VBA, sometimes I may inappropriately express my thinking.

    Now, I completed the coding and...
  30. Re: Communication between class modules in Excel VBA

    I found that Cells.ColumnWidth and Cells.Width return different result, but could not know the difference yet. Anyway, today, I could get satisfied result after changing it to Cells.Width. I also...
  31. Re: Communication between class modules in Excel VBA

    Thank you for your answer.

    It seems that there is no way to directly access class DataRegion at class Bars. So, because I can access to both dauther classes at class Table, I added a property in...
  32. [RESOLVED] Communication between class modules in Excel VBA

    Dear all,

    I am beginner or VBA programming and trying to make class modules that manupulate a table. Overall structures of these class modules are like this:

    clsTable -+- clsDataRegion...
  33. Replies
    7
    Views
    9,318

    Re: Runtime error 458

    Thank you for your comment.

    1) prjExpMaxNum is declares as public constant of 128.

    2) Oh, I did not know I may use "&", not "+", because I could not notice any differences.

    4) I had made...
  34. Replies
    7
    Views
    9,318

    Re: Runtime error 458

    Thanks...
  35. Replies
    7
    Views
    9,318

    Re: Runtime error 458

    Yes, I am using MS Office Excel 2007 Korean version and <Microsoft Visual Basic Info> says like this:
    Microsoft Vusual Basic 6.5
    Copyright 1987-2006
    Version 1040
    VBA: Retail 6.5.1040
    ...
  36. Replies
    7
    Views
    9,318

    [RESOLVED] Runtime error 458

    I am using VB 6.5. I coded following function, and unexpectedly hit to runtime error 458 in the last line "End Functon". Could anyone solve this problem? This function returns string composed of...
Results 1 to 36 of 36



Click Here to Expand Forum to Full Width