Dear Roy
I have responded to your message from 2021.
I have been busy conversing with Ali tonight
I sent along explanation as to why I have problems remembering to Ali but the sheet has been removed.
I have a short term memory problem and sometimes I forget things NOT purpose.
In order not to run foul of the Moderators I will keep my post to one or the other Sites.
I did post the link here after it was explained how to..
Regards
Peter
Dear Roy
Pardon me for not answering your post from Jan 2021.
I have been read the riot act re cross posting the links etc
I will try to be more respectful in the future
Kindest regards
Peter
6/1/2022
Display MoreGood afternoon all
This question is related to the 2 files attachedLoad Plan Form.xlsm
If anyone can please advise as to how to add multiple horizontal lines
inside a textbox of a Form.
My search on line is very confusing.
Thanks in advance for any help
Load Plan Form.xlsm
Trip Planner Master In ProGress.xlsm
Please note This Thread is also appears on the Excelforum site
under the same Title name
This thread is closed due to duplicate threads
Good afternoon all
This question is related to the 2 files attachedLoad Plan Form.xlsm
If anyone can please advise as to how to add multiple horizontal lines
inside a textbox of a Form.
My search on line is very confusing.
Thanks in advance for any help
Load Plan Form.xlsm
Trip Planner Master In ProGress.xlsm
Please note This Thread is also appears on the Excelforum site
under the same Title name
Solved elsewhere
I have a file that I require to copy data from the main page " Repeater Directory 201217 ", across to
each of the destination pages, then sort each destination page by column " B " from low to high
From the " Repeater Directory 201217 " sheet search for a call sign governed by the numeric number in the 3rd character : ie VK1???, VK2???, etc
All data starting with VK1 gets copied over to the Sheet named VK1,
All data starting with VK2 gets copied over to the Sheet named VK2, and so on
I have manually copied some data over to the sheets VK1 and VK2.
There are several blank rows as that is how the data is supplied to me, These lines separate the different Frequency blocks starting at 29 mHz and going up to 1200 mHz
I have only supplied a cut sample file as the main file is too big to upload
Any clarification please ask me
I have tried to explain in as fewer words as possible.
Many Thanks in advance
Peter
Please Note also posted on the Excel Forum site.
Hi
I get the error when I click on the Command button on the FRONT sheet.
Pete
Good afternoon Roy
Thank you for your reply, as a matter of curiosity what version office are you running.
Regards
Pete
Justin Doward is aware of this call for help
The attached excel form was created by Justin for me it runs AOK on his system, when I run the file here on Office 2016 it is returning the error
Run-time error 1004.
" Unable to get the sequence property of the worksheetfunction class"
Can anyone give assistance to clear this error please
Att Roy
Good Evening
Once I worked out what to do, I tried to edit my thread but the system would not let me do so.
Regards
Pete
Good afternoon all.
I would request some assistance to add additional code to " Clear contents " in cell F3 within the code below please.
Thank you in advance
Peter
Sub RemHighlight()
Selection.Interior.Color = vbWhite
End SubJustin
Is it info from me or what, just drop me a line.
Pete
Hi Justin
Any clues as to why the " Highlight Identified Word " code has stopped working please.. ???
Good Evening All
I have a cell say ( A1 ) that has about 200 words in it,
I wish copy another 100+- words from Cell (A28 ), into cell ( A1), HOWEVER
some of the new group of words are already in A1, I would like to not have duplication's.
I have a search on excel help and I could not find a solution.
Peter
Hi Ali
" Please explain" as our rebellious Poly says.
Peter Ohh with 2 working eyes now not quite 100% but getting there.
Hi All
To moderator's if my " Title " does not comply PLEASE advise.
I have a variation on my Word finder program, this one has a set of clues which will be on the " Finder sheet" cells B21 to R26
I am using the same coding that Justin wrote, which is what I would like modified to suit this particular program.
1/ On the "Finder" sheet cell B1 shows the words obtained and what the remainder is left to find which will reside on the
" Clues " sheet Cell A1, which will contain all the words that will be available.
2/ On " Finder" cell B2 is a command button that when you highlight the found word, it Highlight the word with the colour as in
" Finder" Cell F1, then moves that word from the "Clues " dictionary and sends it to "Finder" Cell B27, and adjusting the word
counter on "Finder" cell B1, then places the last word found in "Finder" Cell F3.
3/ The 2 Command buttons in "Finder" in cells J,K,L, are functioning AOK.
4/ On the "Finder" Cell M1 the word sorter command needs attention.
I hope I have given enough information.
Regards
Thank you to anyone that looks at this thread.
Peter
Posted elsewhere
Good afternoon
Thank you for your quick reply and solution.
Is there anyway of freezing the top 3 rows without those lines appearing please.
Pete