Tagged Questions
0
votes
0answers
7 views
Is there any way to speed up excel comparision in VBScript?
I first made a VBA script to compare two excel files. Then optimized it using Variant as said in this question. But then, I changed it to VBScript later. Here the method said above doesn't seem to ...
0
votes
0answers
6 views
VBA ERROR : object variable or with block variable not set
vba error: object variable or with block variable not set
I have no idea what has just happened! Please help. Here is my code!
If intMsgBox = vbYes Then
Unload frmNewOrder // error here
Unload ...
0
votes
0answers
6 views
i have a userform in excel which i want to convert to an addin or menu item in excel 2003
i have wriiten a small vba code(userform & modules associated) for concatenating files in a user inputed folderpath. Currently i have this placed in personal.xls and everytime after opening excel ...
0
votes
2answers
20 views
Microsoft Excel Copy and Paste with Format of Date
Can anyone help me with copying and pasting but keep the format of the data to be date for all the dates and numbers for all the numbers. So for example I have Customer ID which should be 3 digits ...
0
votes
1answer
22 views
I am running a private sub in a worksheet. Can I click something to enable/disable it? i.e. Can I program a button?
This is my code. It is a function that makes it so that when I click a single unlocked cell, it increases the value by one. I am having a problem getting it to always run. Sometimes it runs, sometimes ...
0
votes
1answer
22 views
Custom Auto-Sort Macro Excel
I would like to customize the below macro. What I would like the macro to do is auto-sort as per the below list. Any suggestions on how I could go about doing this?
Thank you.
Code:
Private Sub ...
-2
votes
0answers
30 views
Create an “if then statement” or UDF
How do I create a User Defined Formula or a VBA that does the following:
Looks at the values in range B1:B3 if the value matches cell H11, paste the value of cell A1 into the cell A10
Then if a ...
0
votes
2answers
11 views
How to use variables in range assignments
I would like to use variables that I can pass to a SUB for coping an array from one sheet to another sheet in another workbook. Without variables this works well for me:
Dim RNG1 as Range, RNG2 as ...
0
votes
2answers
24 views
Today`s date in an excel macro
I am trying to add a today`s date to column A in sheet2 each time my macro paste my selection of sheet1 in column B of the new row of the sheet2.
My script work to add the new row and paste my ...
0
votes
0answers
24 views
Strange prooblem Excel VBA? wrong with my code?
I have a main excel file called Main.xlsm contains two sheets, sheet 1 "Main" where i have all my codes written. and sheet 2 "Work" where i do all my cut copy formatting everything.
In main i have a ...
1
vote
1answer
27 views
How to dynamically get the value of current multipage tab value?
Community, I am currently hiding my tabs on my userform multipage except for the current tab. The user can click buttons to switch back and forth between pages. Some buttons share sub routines. ...
0
votes
1answer
21 views
Excel Userform Textbox Value Not Updating When Changed
I have been scratching my head on this for a while now and after a lot of Google searches I have not found an answer. I am just learning how to write this stuff, so sorry in advance if this is basic ...
0
votes
1answer
18 views
Reorder hidden tabs in excel
At work, we've developed a tool using Excel and VBA. This tool has hidden sheets that will only be opened once the previous step is complete. One of the issues I'm running into from the previous coder ...
0
votes
0answers
32 views
VBA: Referencing a named range and insertation of that named range
Sub Sort3(a As Range, b As String)
' This
' First part checks for player salary and descending then if true, then clears and sorts descending
If b = "Descending" Then
...
0
votes
0answers
11 views
Macro to validate cross references in Word and extract into excel
Is there a way to create a macro to review cross references? I have documents that I am required to check cross references for validation, for example Paragraph 1 references Reference 1.
I'd like to ...
