0:00
So up until now I've shown you a screen cast on how we can add a category,
how we can add a record.
Now I didn't show you, and I'm not going to show you, screen casts for
the remaining buttons.
Delete category should be pretty easy, you can record a macro for how to do it.
Delete record should also be quite easy.
The differences you have to also have a combo box just like the add record.
So you need to populate the delete record user form with all of the rows or
names on the spreadsheet.
0:32
The search and replace tool I'm going to leave up to you guys.
It's more connecting the dots, it's more challenging.
I didn't want to give you a whole lot because
I think that there's some aspects of this project, and these projects,
that you really need to kind of figure out yourself.
I do have some information in the Grade Manager project.
There's also a kind of a search tool.
So if you want to jump to that, even if you're not doing that project,
it's the hardest one in the course.
You can jump to that and look through the search and replace tool.
I think it's pretty similar to this one.
And you can also post questions on the discussion forum and
help each other on these projects.
So in this screen cast I'm going to show you how you can just quickly
add an icon to the quick access bar to open up your project.
You probably don't want to put a button here because when you delete
rows what will happens is that the button will shrink in size.
And then if you delete a column where that overlaps with the button it
will shrink it this way, and
at some point your button just gets shrunk to something really small.
So instead of that I'm going to show you how you can add an icon up here,
it's called the Quick Access Bar.
So let's go ahead and go into the File menu.
And you can go down here to options and
then in the Quick Access Toolbar, so click on that.
Popular Commands, change this to Macros.
You don't want this to be applied to all of your documents, so click here and
do just for this file, the current file that we're in.
And then in the Macros, here on the left, we can go down to our RunForm macro.
2:18
And if you don't like that icon, I don't really like that icon, so
I'm going to go ahead and modify this, it brings up a bunch of different options.
You could put a smiley face if you wanted to.
I'm going to just do, there's an icon down here that sort of looks like
a kind of like the project that you're going to be making,
the ultimate organizer, so I'm going to click on that.
And then I'm going to click OK, and I just click OK again.
And you notice up here on the Quick Access Toolbar, we have that icon, right.
So the user could either go in here to the Developer tab and
then click Macros and click Run Forum and run that.
Or you can just simply click on this icon and that brings up the user form, so
that brings up your project.
And for this project you're going to want to do this for just the main form of your
Ultimate Organizer project, not the Add Record form.
The Add Record form comes off of the Main form.
Charlie NuttelmanInstructor
