Search:
Type: Posts; User: Siddharth Rout
Search:
Search took 0.37 seconds.
-
See the solution by Jaafar Tribak. This solution doesn't need "TLBINF32.DLL".
...
-
I know I am late for the party but this may help any future visitor so I will go ahead and post a solution.
The .Find is happening on wsWFD.Columns("E") so .FindNext should happen on that range.
...
-
Dan has already given you the answer as to why you are getting that error. It is important that you qualify your objects completely.
As a personal preference, I always declare objects and work...
-
Ok you gave me an idea. It does solve the problem and for that due credit to you (rated your answer)
I set the Autosize = False and then set it to true in UserForm_Initialize()
Private Sub...
-
Autosize = True will not help. It is already set to Autosize = True at design time. I then resize the control and make it very small. I want to resize it at runtime.
-
I am stuck in a very peculiar situation. Seems like no one has ever asked this question before or maybe I am not able to search for it.
There is a Userform in Excel. It has an Image Control. It's...
-
Also use "Long" instead of "Integer" when working with Excel rows. I guess you are getting the error because of that.
Change
Dim MaxNum As Integer
Dim ChooseColumn As Integer
-
Also use "Long" instead of "Integer" when working with Excel rows. I guess you are getting the error because of that.
Change
Dim MaxNum As Integer
Dim ChooseColumn As Integer
-
A small suggestion.
Avoid the use of .Select/.Activate/Selection/Activecell/Activesheet/Activeworkbook
Two Main reasons why .Select/.Activate/Selection/Activecell/Activesheet/Activeworkbook...
-
Change
Dim username As LongPtr
to
Dim username As String
-
When you are writing a formula you cannot leave it to the user. There are lot of things that you need to consider. For example
1. Have they entered the correct syntax?
2. Have they entered the...
-
What is the value of `TextBox3`?
-
Unfortunately, the code that you are using is not meant for such complex operation. You will have to re-do the code from the scratch keeping all your requirements in mind. Mind you, it will not be a...
-
Hi Stephen
Got your PM. Slightly busy with other projects and hence was not able to reply on time. Anyways, I see lot of posts above. So if you want me to effectively and quickly help you then can...
-
You do not need to write so many lines if you want to remove them. Here is a shorter way to do it :)
Sub replChar()
Dim ws As Worksheet
Dim rng As Range
Dim SpecialCharacters As...
-
Here is one piece of code which you will rarely see being used :)
You can TRIM a range in one line i.e without looping.
Sub Sample()
[C1:C1000] = [INDEX(TRIM(C1:C1000),)]
...
-
The code by Ken is good. Go ahead with that :)
-
I have not tested this but try this. This will not leave an instance.
Sub main()
Dim oXLApp As Object, oXLWB As Object, oXLSht As Object
Dim QuitIt As Boolean
'~~>...
-
If your query is not resolved then you do not need to mark it as resolved :)
-
You seemed to have missed what I mentioned in post #25?
Is this what you are trying? I fixed the Caps issue as well.
Option Explicit
Sub Sample()
Dim MyArray() As String
-
>>>Is there any way of removing the Input box so it can be added only if needed? As in putting the code in a comment?
Yes put a single quote before it :)
'This is a commented code
...
-
I hope TG has cleared the confusion regarding merging of the threads :)
Did you try the code that I gave? You can easily remove the entries using that code.
-
I answered a similar question 8 years ago :D
Is this what you want?
http://www.vbforums.com/showthread.php?562763-How-to-add-checkboxes-in-subitem-of-listview&p=3478144&viewfull=1#post3478144
-
Sorry was having Dinner. Replace
'~~> Highlight duplicates
For Each itm In Col
Selection.Find.ClearFormatting
Selection.HomeKey wdStory, wdMove
...
-
You mean just highlight the text or the number?
-
Great. If your query is solved then feel free to mark the thread "Resolved". If you do not know how then see the link in my signature :)
-
Simply remove the Inputbox and change the line
If Left(MyArray(i + 1), 4) = Ret & "-" Or Left(MyArray(i + 1), 5) = Ret & "-" Then
to
-
I thought you wanted to choose?
-
Is this what you are trying? :)
Option Explicit
Sub Sample()
Dim MyArray() As String
Dim n As Long, i As Long
Dim Col As New Collection
-
Ah I see.. So you want to type "HCI or ERL or MSRS" and it should highlight the duplicate for those?
-
Like this?
HCI-10001
HCI-15002
HCI-15153
HCI-10001
ERL-14122
ERL-15002
ERL-10001
MSRS-51112
-
Well you need the desktop version (MS Outlook - Paid Version). Else do what Pete Suggested. Use CDO :)
-
Great!
If your query is solved then feel free to mark the thread resolved :) If you do not know how then see the link in my signature.
-
That is because there is some space in the worksheet name. Go to the worksheet and retype the name of worksheet in it's tab. Remember to remove the spaces.
-
Welcome to vbforum :wave:
>I have been able to do a bit of code to convert an excel sheet to a pdf and send it via gmail but I dont know what the next steps are
Why not use Outlook? It is much...
-
Is this what you are trying?
Sub Sample()
Dim wb As Workbook
Dim wsI As Worksheet
Dim NewFileName As String
Set wb = ThisWorkbook
-
I guess you are replicating my stackoverflow post? :D That logic will not work here.
Ok quick question. What should happen to these numbers. I mean what output are you expecting?
Before
...
-
So this is what I have understood.
1. You are running this code from the workbook "Blastbag Work Instruction"
2. There are 2 sheets. INPUT" and "DATA"
3. The filename is in cell D8 of INPUT...
-
I only give code in a platter if I am paid for it LMAO (Just Joking)
I can but I want you to try it yourself. Else how will you learn mate?
-
Ok scratch that. Let's start from the beginning.
We will rebuild from the start and we will try and have only one macro in lieu of 5 if possible :)
Explain what exactly are you trying to do....
|
Click Here to Expand Forum to Full Width
|