royUK Super Moderator
- Member since Jan 26th 2003
- Last Activity:
- Posts
- 26,393
- Reactions Received
- 809
- Points
- 133,284
- Profile Hits
- 21,653
-
-
Hi Roy
Please ignore my previous request.
I found another link that I was able to download.
Thks mate!
Rgds
KN
-
Hello Roy
I came across this 2013 thread
forum.ozgrid.com/forum/index.php?thread/125852/to which you had responded as follows:
"Take a look at this example and try to adapt it for your workbook
Password Form v6"
I think the link is not working.
Would be most grateful if could send me at Kieran dot Nayak at Gmail dot Com
Many thanks.
KN
-
You really should check for this before attaching. It not only makes work but often makes the answer harder to understand.
Which posts?
-
can you delete the thread?
-
-
Hello Roy,
even if it cost my membership would it be possible for you to help to delete sensitive data from threads I posted?
thank you -
Hello! I saw you deleted my thread here. Could you please delete this thread as well? Thanks in advance!
My reconciliation VBA macro takes too long to reconcile thousands of data entries
-
You have had a reply to that one.
-
is it possible to delete instead of closed please? It’s an exception, would like the thread to be removed
-
Why do you want it removing?
-
Some details need to be removed or edited out on the thread, preferably removed
-
-
Hi,
I know you r more busy.
It will be very helpful for me if u go through the link and thereby help me to ensure the VBA.
Excel VBA for printing multiple pdf file by its name, sequence and no of copy from excel column
-
Hi my excel guru,
Hope your well.
I know your busy, but was hoping you can pick up on my latest question in the forum that I posted earlier today.
regards,
Lee -
Hi Roy,
I have 2 Dropdown List with the same options (Included and Excluded) in different sheets. If I select " Included" in one dropdown list, it should also select "Included" on another dropdown list and vice versa. I am new in coding please help me out to crack this.
-
Ask your question in the Forum, not individually.
-
-
Hey Roy
I'm really thankful for the help , you'r my best hope if it will be ok to ask please if you'll have the time to check it , it's like half finished and I know it's not an easy task that I'm asking , thanks anyway .
best wishes,
Netanel
-
Hi Royku
Could you please view my query and share your suggestions please.
-
Can you pls look into my excel file & share coding pls......
-
I see all new posts and relpis to my posts whenever I log in.
I'll take another look as soon as I can
-
Hey Roy,
Thanks for your response to my thread.
Unfortunately your solution has not solved the problem which i think is down to my explanation of the problem.
I have responded to your reply on the same thread but was not sure if this would notify you in any way so thought it would be best to give a message here as well.
Please, if you have time, could you look at my response as i am confident that i have adequately explained the depths of my problem.
Thank you very much.
-
Hi Roy, I create a post last week and i wasn't accurate at first, Can you take a look again?
Macro to build Searchable drop down list
Thank you in advance
-
Looked like a question. You said that your code didn't work.
-
I was just placing my ideas not asking.
Thanks anyway.
-
Hi,
Please help me on below code. When I run this code I haven't get any error, but at the same time not getting any result too.
Sub New_Method()
'If date in coloum C is less than today and cell in coloum E is blank (in the same row), then fill that blank cell with "my text" in coloum E.
Dim rng As Range
Dim sh As Worksheet
Dim lastrow As Long
lastrow = Range("C" & Rows.Count).End(xlUp).Row
Set sh = ThisWorkbook.Worksheets("Entry Page")
'Set the range in column C you want to loop through
Set rng = sh.Range("C2" & lastrow)
With Worksheets("Entry Page")
For Each Cell In rng
'test if cell is empty
If Cell.Value < Date And Cell.Offset(0, 2) = "" Then
'write to adjacent cell
Cell.Offset(0, 2).Value = "My Text"
End If
Next
End With
End Sub
-
You should ask your question in the VBA Forum. Read the Forum Rules first and use Code Tags
-
-
Hello Roy,
I tried to start a conversation with you but it was not possible.
Maybe could you please delete the excel file I shared here Dynamic Urserform, I will upload another file.
Thank you -
Hello Roy,
If you will find a few minutes can you change/tell me what I should change in code ?
Use Macro on Teams/Sharepoint/Onedrive -
Don't ask questions here, post it in the relevant Forum
-
Hi...need your help with multiple dependent combobox. I have 3 combobox and if any one of the 3 is selected based of the selection the other 2 should get refreshed.
-
I'm re-writing the web site at the moment. Message me here for now
-
Hello. I tried to send you a message in the contact section of your website but it doesn't work
-
I know what XLOOKUP is, I just wanted to be sure that you had Microsoft 365
-
Ah! now I understand about the code button (Spinning my noob propeller). Xlookup is new and comes with Office 360.
-
Hi Roy, I read the rules (twice) but obviously must be missing something; my apologies. I'll read them again and see if I can work out what I'm missing. Thank you for your time and the solutions to provide, they make great reading, and it really helps a self taught noob like me.
-
Hi Roy,
I'm new to this website. I had a question on VBA and created a thread which I posted. It is basically autofiltering the data pivot tables to display only 6 months at a time. I hope you could assist?
coqueiro23
Hello Roy!! How r u doing??
I'd appreciate VERY VERY much if you can help me with a Excel workbook (you already answered me before)!
It's an emergency!
Thank you!!!!