Search:
Type: Posts; User: skparkcn
Search:
Search took 0.03 seconds.
-
If it is, no way.
Thank you for your reply, westconn1.
-
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...
-
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...
-
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...
-
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
-
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 =...
-
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...
-
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,...
-
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...
-
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...
-
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...
-
Dear everyone
I coded following:
ReDim rngFound(LBound(Keywords)) As Range
Set rngAllFound(LBound(Keywords)) = FindRanges(Keywords(LBound(Keywords)), rngAllRef, myxlRow)
...
-
I solved my problem when I followed westconn1's recommendation.
Thank you westconn1 and koolsid.
-
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.
-
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....
-
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...
-
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...
-
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.
-
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.
-
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,...
-
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.
-
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...
-
Dear westconn1
Thank you for your kind answer. Your help solved my a week of trouble.
-
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...
-
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...
-
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...
-
-
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,...
-
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...
-
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...
-
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...
-
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...
-
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...
-
-
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
...
-
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...
|
Click Here to Expand Forum to Full Width
|