All Questions
354
questions
1
vote
1
answer
53
views
Data validation reference provides value and not associated list values - VBA Reference Errors
It seems I'm running into a relative reference problem with the INDIRECT formula in the data validation section of my code.
I am trying to create a macro that will automatically update and format ...
- 11
0
votes
0
answers
35
views
Using Forms, how to call sub classes from an eventclass
I have several forms and several TextBoxes in each form. To isolate the code I use a class CCtrlTextBoxEvent
enabling events: Public WithEvents txtbox As MSForms.TextBox and i get callbacks on ...
0
votes
1
answer
34
views
Edit VBA to scan a document and pick out the reference numeral that corresponds to a string, e.g. output "102" for "dog 102" in the document
My current code to do this works when all instances of the string in the document are accompanied by the associated numeral. However, where some instances of "dog" arent followed by "...
- 23
1
vote
3
answers
54
views
How can I reference the active cell within a loop through different sheets?
I am stuck where it is properly reading that I have two rows that fulfill the "If" condition, but it is copying row 1 both times on separate sheets, rather than row 8 and 10. Is there a way ...
- 13
0
votes
2
answers
90
views
Application.FileDialog not referenced?
Since my research has led me to belief that my references could have something to do with it ,here my references to my MS Access:
Visual Basic for applications
Microsoft Access 16.0 object library
...
- 137
0
votes
1
answer
26
views
Filling multiple blanks among texts in a cell using values from other cells
I am using Excel VBA to automate following task.
In Cell D2, i have the following wrapped text:
"My name is C2 , I am from C3, i love reading A3 type of books. My favorite sport is B6 . "
...
- 15
1
vote
2
answers
55
views
strange behavior : How elements are inserted in vba arrays?
Can any one explain me the following code behavior ?? -->
Public Type User
firstName As String
lastName As String
End Type
Sub test()
Dim userList(1) As User
Dim ...
- 11
0
votes
0
answers
47
views
"Can't add a reference to the specified file.", when trying to update VBAProject reference mscorlib.dll version
Got new computer and I am unable to get my previously made Excel VBA macros work.
Problem lies in mscorlib.dll, what I can't update from v2.0.50727 to v4.0.30319.
Message "Can't add a reference ...
1
vote
1
answer
38
views
Array of String Cell-References Passed into New Row of Table is Not Displaying Referenced Values
I have a script that arranges user-fillable data into item slots in a sheet, while having that same data represented in another sheet as a table.
Each time a slot is generated, each cell in that slot ...
- 13
2
votes
1
answer
246
views
VBA Printer and Printers object requires installing Reference library?
I have a question for Printer object and Printers object in Excel VBA. Is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object?
I run below ...
- 21
0
votes
1
answer
90
views
fast reference in Microsoft Word with VBA
I have written two modules in the MS Word that can boost the speed of creat hyperlink for two words that they reference to each other:
This is useful specially when we want to reference many words. ...
- 155
0
votes
1
answer
35
views
The function cell.Text() does not work when calling sheets
I have a workbook that has 10 tabs, some are hidden, but I don't think it matters for my purpose. On the "SQL" tab, I have a mapping of what I want the new sheet name to be (see A14:B24). I ...
- 103
0
votes
2
answers
78
views
How to allocate amount of rows according to amount of rows in another sheet
How do I insert amount of rows according to data from another sheet?
I have 5 data out of the 10 rows I have (I keep the empty rows for spare)
How do I make it so the data here corresponds to the ...
2
votes
2
answers
84
views
Assign a calculated value using user defined function
This version is cleaner and easier to read. The conditions are evaluated top-down, so once a condition is met, the subsequent conditions won't be checked.
Function GRADE(ByVal cellref As Range) As ...
- 23
0
votes
1
answer
519
views
How to Automatically set Excel VBA References?
I understand that the references I've used within my script require extra references to run all of the functions I am using but I now need this to be shared with many other people. They are all common ...
- 11