i need my code to find all data i seach for , my code is working well but find just one target
Private Sub CommandButton8_Click()
Dim valFIND As Range
Dim iRow As Long
I'm a very green 'programmer' and I'm having some trouble with having a dropdown object in 'sheet1' that I want to display all the sheets titles.
Here is what I have for the code:
“Despite my past affair with Crystal Reports, I have to report that I’ve thrown over my loyalty to Stonefield Query. The simplicity and depth of the program make it easy for me to recommend. “...
How would I create my custom Role class based on that autogenerated class? I have read a few articles on the net but I am still lost. Can someone please show me how to do this, and what I must...
I am completely lost trying to write this macro. I am trying to use the Powerpoint.Application object to access an existing presentation and search through all slides for text "xxxx" and replace with...
This is my first query at this forum, I'm very new with Macro.
I have an excel sheet for which I need a macro to send email automatically on specific dates.
I prefer to open up the...
How can you have done so much coding without relying on variables? Bizarre. Well I'm guessing it's too late now, but for reference's sake, this is how you declare and assign a value to a variable in...
what does # and ! mean in VBA coding?? thanks alot =)
can anyone help me converting the qbasic code below to macros in excel... especially the Read and Data part... it seems that macros in excel doesnt read Read and data statment... Thanks you =)...
Where are you at thus far? You should be able to qurery each separate worksheet and build a master. From there the manipulations will be much easier.
Man, I need to re-read all my VBA books & training videos again!
If you can help me with this question I would really appreciate it.
I am wanting to create and populate a variable “HUTID” with...
Thank you very much for the help. I couldn't have done it without you!
Everything works well so far. It took a little longer to set it up but it is ok now.
Check that the same reference are listed the same in Access 2010 as Access 2003.
From your VB code page, Tools - References
Pls help me!!!
I have listbox with some items into it say 100. The user will select...
Hi Dragonfyre, I don't understand what you mean by reference the cells, do you wish to do something with the values in those rows, or simply select that range?
The example below assumes the...
Well that code still gives you the last occurrence of any value in that column, which is what you'll need if you're trying to select all the values you have, it just means you'll...
I really appreciate your views on macro.
I am trying to write some code that will utilize an input box to find a value. At that point I want to run a macro that will reference the cell rows of all values that equal the input box...
"To answer your first question, assuming you have no gaps in column A, you can find out how many rows there are using the following code:
Dim LastRowColA As Integer
hi, i am a new to using VBA and would appreciate if any one would be able to help me.
i have two list boxes, one for companies (ListedCompanies) and the another listbox for the chosen companies...