I don’t know enough about Forms to help out with that portion.

There are lots of places on the web that could provide instructions. Google around to see what you can find.

As far as the Find button goes, if I were you, I would include instructions on how to add the Find icon to the toolbar. As I outlined in my previous post, the steps are quite simple. If the user can’t pull down a menu and drag and drop an icon, well, what can I say.

Can they press Ctrl-f? That will bring up the Find box.

If you really want to add a custom button, then you’ll need a Macro. You’ll also need to make sure that Macros are enabled on any machine that will use this button. If they are not enabled, then you’ll need to provide instructions to the user as to how to enable Macros. If they are able to follow those instructions, then they should be able to follow the instructions to add the Find icon to a toolbar, which would then be available in any and all spreadsheets they open. You’d be doing the user a big service by teaching them something new while making the Find icon available whenever they need it.

All that said, here’s your button:

1 – Press Alt-F11 to open the VBA editor.
2 – Click Insert…Module
3 – Paste the following code into the pane that opens.

Sub MyFind()
 Application.Dialogs(xlDialogFormulaFind).Show
End Sub

3 – Close the VBA editor
4 – Create a shape in your workbook or on your form.
5 – Right Click and choose Assign Macro.
6 – Locate MyFind in the list and double-click
7 – Back in the spreadsheet, click anywhere to deselect the shape
8 – Mouse-over the shape and the cursor should become a link-finger.
9 – Click the shape

Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

See less

Hi,
You should create your own thread if you ahve a question and want help.
In general, you have a few options to do the upgrade.
1- You an go through the ‘Get Windows 10’ option icon.
2- You can do the Download Windows 10 directly and install it.
3- You can run the media creation tool (as above) to create a DVD in order to install it from outside of Windows, on machines which are having more software issues and you just want to do a clean install, or if you want to install it on multiple machines and do not want to do the download for each one of them.
The first two will walk you through everything without needing any instructions as long as you read each of the questions before hitting OK (always recommended). The last option is more for tech people who would know how use the ISO image to create the install media and want to do this extra step to possibly save a few steps later.
A lot of people want to trash MS but they are still be best game in town. Apple is not any better, they often try to make things appear to be simpler but that is because they tend to hide options, this means that if you want to do something a little differently than they think you should do it, then you have a lot of trouble forcing it to do it your way. With Windows you can often do something 4 or 5 ways depending on your preferences but with Apple you have to learn their way of doing things and learn a whole list of shortcut keys to do otherwise simple things. Yes, short cuts are great and save time, especially when you do them repeatedly, but if say you are not sure how to do something that you rarely do, with Windows you can probably find one of the 6 possible ways to do it yourself but with Apple, it is either use the short cut or go through an elaborate multiple step process that may be even harder to find. They are no better than Microsoft, they control everything from the hardware to the software to how your iPhone will connect. If you really want something different, be brave, build your own machine and install a free operating system like one of the Linux distributions. I have worked with Apple and even a little with Linux and in general, I prefer Windows (I just skip a few when I can (ME, Vista, & 8 (though not as completely as the other two)).

You have to be a little bit crazy to keep you from going insane.

See less