Search results for query: *

I'm not sure what would happen on the fifth click of the AddOrder button. As I said, this project quickly got way over my head as far as my abilities and understanding are concerned. As far as the extra rows being created with each click of the AddOrder button - yes, it is adding the correct...

Sorry for the confusion. What I had in mind was that I would have a 4 row, 4 column table created. The AddOrder button would just add the input from its four associated fields into the first available row on the table. After that row, it would move down to the next available row. It looks...

Actually now that I've taken a closer look at it, I see that each click of the AddOrder button is adding new rows on the bottom of the table, rather than using the existing cells.

Thanks for all the help and the tips fumei. I am very close to being done. The AddOrder button is working and everything is being added to the receipt from the form. For some reason the AddOrder button is dumping everything into the last row of the table, instead of the first, but I will look...

By the way, can anyone recommend a good book on VBA?

Thanks a ton - I will try that when I get back to work :)

I'm sorry to keep coming back with problems. I really appreciate all the help I've gotten with this but it's gotten to a point where I'm completely lost. I didn't intend for this project to become such a headache. I'm just ready to be done with this so I can go back to programming Hello World...

Thank you - that worked perfectly. I apologize for causing so much confusion. I am not familiar with a lot of terms yet.

Okay. Thanks to everyone's help I seem to be on the right track. I really appreciate all the assistance. I didn't think this project would get over my head so quickly. I incorporated my Receipt template with fumei's long length of code he provided. The only problem is that when I bring up the...

The 4 cell prototype isn't what I'll end up with. The final table will most likely have 4 rows and 4 columns.

Wow thanks fumei - as odd as it sounds, I can't wait to get to work tomorrow to try that out. Yeah - my table will have a limit of 4 rows. Very rarely would anyone need to exceed those 4 and if they do, they can just revert back to the old receipt we used to use. I'll try messing around with...

Hey - I think that might work for me! It's almost the end of my day here so I'll take a break for a post-work bike ride, beer, and sleep (in that order). Thanks for the great help. When I come in tomorrow I'll start fleshing out the example provided to suit my exact needs. If I have trouble...

I apologize for not making myself clearer. I'll paste my entire code so far at the bottom of this reply. I plugged your code into my UserForm, modifying it slightly for the cmdAddOrder event and replacing the "1" and "2" values with the cboPubName and cboTerm selections. Sub...

The table exists as a way to allow the user to add more than one line item on the receipt. So if a customer orders 2 products, then two rows on the table will be used. If they order 3, then three rows would be used. And so on... The AddOrder button would exist for this purpose. If only one item...

I am using Word because I can create a nicer looking receipt in Word. I'm just not experienced enough in Excel I guess to make the receipt look the way I want it to look. The table I am using is just a single aspect of the receipt and I haven't found a way to create a nice document in Excel...

I am using Word because this will be a receipt which will be emailed to a customer as an attachment. The UserForm will initialize with the opening of the Receipt template I created.

I am trying to create a UserForm for our customer service reps to use with a template when sending a customer a receipt. The receipt will sometimes need multiple order lines, so I decided to use a table within Word for the order lines. This is all being done in Word. In order to begin...