Project 3 – Week 3 (Day 1), – Editing the Bookings Page

So I didn’t really get to accomplish much again today. I’m getting pretty frustrated again.

I’ve started to work on actually setting up the booking system. I’ve added a booking button, and have returned to editing the Userform.

The first thing I did was try to complete the whole Userform. I quickly encountered a problem with my Userform. I tried using a combobox (it’s like a pick list), but I had a really hard time trying to add in the choices to pick from.

Properties List

The image above is called Properties. I find it really hard to add in the info for the combobox. I tried searching it up, but none were particularly helpful. Eventually, I decided to move on and try out something else. I just added in an option box (pretty simple to use. I was able to figure it out as soon as I tried it. You just click the button in the toolbox that has a shaded circle. Then you label it.) as a substitute. I’ll go back to it later, if I can.

Once I was done with that, I thought about how I was going to organize the information of the Userform. What I’m planning to do is this:

  • Since I’m only going to have one booking page, when you fill out the userform, it will be sent to a page.


This will be sent to here (or something like this) :

Customer Info

Then, when the info is all laid out onto the Customer info page, I’ll use an if statement (and maybe a conditional formatting, not entirely sure) to get customer information to make the color of the bookings table turn into a corresponding color of the type of customer the person is (e.g. Adult, Senior, Student).

I realize that I may have to use a lot of if statements and conditional formatting. I’m probably making it harder on myself, but I want to have some originality in my project. Still not quite sure how this is going to play out. I know I’m going to have to create a legend for the bookings page. I’m not sure if I’ll be able to pull off all the nested ifs and conditional formatting. This whole thing is getting pretty confusing.

About jaoj2

Sha Tin College 10S
This entry was posted in Project 3 - Rockschool Excel Project, Projects, What I Did Today. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s