Search:
Type: Posts; User: bolcskei
Search:
Search took 0.09 seconds.
-
error 1004. rountime (left) cannot be resolved.
-
Hi guys,
I would like to add some functions to my SQL. I have the following code, bute I would like to change it to another one. has anybody an idea?
pls help.
Boris
before
-
Hi gyus,
I would like to create a small routine, which give (showing the yellow tip text box) me back during mouse over event the chart height and width
Has anybody idea how to do it?
...
-
the filename is name of file I have opened. when I work with exported databased, the sheet has equal name as the file.
for example PH060405
-
Hi to all,
can anybody tell me why this code is wrong? Both of files are opened.
Workbooks(filename).Sheets(filename).Range(Cells(1, 3), Cells(50, 3)).Copy _...
-
Thanks for a tip I will try it. Somethimes I am asking primitive things, because I am not a programmer.
-
I was checking the problem. I think the problem is, after I open the file I can just use the name of the file, without the filename path.
thefore I have to from this:
C:\Documents and...
-
Hi guys,
I would like to set colors of active workbook equal to a selected xls file. To do this I would like to use msoFileDialogFilePicker. I have the following code:
Private Sub...
-
I would rather open and hide file and read data from opened file. Thanks.
-
Hi guys,
As a part of an Excel add-ins, I would like to load colors from a selected file. The code described below wrote me back an Error 9. It is because my intention was load colors from...
-
I have only VBA and thefore I was not able to import your example.
-
what kind of picture file I can attach to imagelist?
-
I was already trying do it this way. But after defining imagelist and images I did not see imagelist in toolbar as you described it in step 4. Do you have any idea, where is a mistake?
-
Hi guys,
Can anybody help me how is it possible to define an imagelist for userform?
I would like to create userform with toolbar and I would like to define form some buttons icons.
Thanks.
...
-
Hi guys,
I would like to prepare code which will color pivotfield.pivotitem.labelrange. So far I have prepared the following code:
Dim pvtfield As PivotField
Dim pvtitem As PivotItems
Set...
-
I did not know that. I do not like to use linked cell, because I like to prepare macros independent to opened file. Of course the linked cell I use with controls in Excel.
But, thanks for an idea.
-
I did a mistake. Textbox do not have click event.
-
I have MS Office XP.
"Showing" spinbutton value in textbox I have done. It works fine. But I would like to do a opposite procedure. To set the value of spinbutton based on the value of textbox....
-
I am sorry. It is in Excel and I have VBA.
-
Hi guys,
I have probably very simple problem. I would like to set spinbutton value equal to textbox. I am using the following code:
Private Sub TextBox3_Click()
UserForm1.SpinButton2.Value =...
-
I do not like to use selection too. But the first code was my first try for my problem. Now I have better solution, but I am still not satisfied with it. But it work as I wanted.
-
Thanks for a try. Insteade of my previous code I have start to use this one:
Set pvtField = ActiveSheet.PivotTables("PivotTable1").PivotFields(j)
s = pvtField.VisibleItems.Count...
-
Yes I want to do it in Excel. I am using this code. But I do not want to use a selection method
ActiveSheet.PivotTables("PivotTable1").PivotSelect "" & i & "[All]", xlLabelOnly _
, True
...
-
Hi guys,
I would like to format interior color of all labels of a certain pivotfield. Has anybody idea?
Thanks.
Boris
-
I wrote in my post. Have in an add-ins textbox, where I can copy SQL query code a have possibility to find a selected text and replace it with another.
-
I know, that when I create excel file I can save it as add-ins. But I did not see such a possibility in access. May be it woulb be enough for me have any access file which can be modified. I think I...
-
Where I can do these steps. I have only VBA. Did you meant do it in visual studio?
-
Thanks for a try, but I do not think that add-ins is suitable for my problem, may be I have described my intention in wrong manner. Somethimes I am editing SQL command copied from Access in Word...
-
Hi guys,
I would like to create add-ins for MS access. I am already long time bored during editing SQL code copying it to MS Word and using find and replace function. I would like to do add-ins...
-
For example you can have
Private Sub ComboBox1_Click
and I would like to have something for pivots
PivotTables("PivotTable3").PivotFields("year")_Click
or perform some action after changing...
-
Hi guys,
During my work I am using pivots in reporting in Excel. Can anybody help me how is possible to make pivot field combobox event sensible? For example change event.
Sincerely
Boris
-
Hi Hack,
Sorry, I have understood just the first question. The macro is a part of excel file and the excel file was just copyied to the other machines. everything is done in that file and thefore...
-
yes. but actually machines of my collagues do not know "date", thefore I have tryed to use "now". These machines as I wrote do not know "format" function.
and I do not know why.
-
Hi guys,
I have urgent problem. I have finally prepared an excel file where in the modules I am using format function.
UserForm1.TextBox1.Value = Format(Now, "dd.mm.yy")
This code is running...
-
Many thanks. I have tryied your suggestion at home and it works. I have shortened the query enough.
Boris
-
It works, but I have an userform using which I can do almost any combination of query. I can choose to see any column, I have possibility to use up to 5 ordering criteria and combine with 3 where...
-
Hi to all
Happy New Year to everybody.
Guys I have the following procedure to create query in excel. I have changed the whole command text by a combinations of several strings (select, where...
-
-
I have Visual Basic Editor as a part of office and thefore I think I have VBA.
-
That time I have changed it to
Private Sub Textbox4_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
If Button = 1 Then UserForm2.Show
End Sub
But it did not worked. I...
|
Click Here to Expand Forum to Full Width
|