How to add an icon to the Quick Access Toolbar to run your user form

Loading...

En provenance du cours de University of Colorado Boulder

Excel/VBA for Creative Problem Solving, Part 3 (Projects)

45 notes

Explore Related Videos

At Coursera, you will find the best lectures in the world. Here are some of our personalized recommendations for you

University of Colorado Boulder

Excel/VBA for Creative Problem Solving, Part 3 (Projects)

45 notes

Cours 3 sur 3 dans Specialization Excel/VBA for Creative Problem Solving

In this course, learners will complete several VBA projects. It is highly recommended that learners first take "Excel/VBA for Creative Problem Solving, Part 1" and "Excel/VBA for Creative Problem Solving, Part 2". This course builds off of skills learned in those two courses. This is a project-based course. Therefore, the projects are quite open-ended and there are multiple ways to solve the problems. Through the use of Peer Review, other learners will grade learners' projects based on a grading rubric.

À partir de la leçon

Intermediate Projects: Lesson Choices

Introduction to the Ultimate Organizer project7:58

A demonstration of the Ultimate Organizer7:38

How to add a category7:21

How to add a new record, Part 18:00

How to add a new record, Part 23:50

How to reveal hidden labels and text boxes9:22

How to add an icon to the Quick Access Toolbar to run your user form3:26

Rencontrer les enseignants

Charlie Nuttelman
Instructor
Chemical and Biological Engineering

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.

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.

And then go ahead and click Add.

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.

So hopefully this helps and hopefully you guys will take advantage of this and

put little icon in your Quick Access Toolbar.

Explorer notre catalogue

Rejoignez-nous gratuitement et obtenez des recommendations, des mises à jour et des offres personnalisées.

Coursera propose un accès universel à la meilleure formation au monde, en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.

© 2019 Coursera Inc. Tous droits réservés.

Télécharger dans l'App Store

Disponible sur Google Play