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.
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) :
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.