Macro for adding new fields to a list

kikz

New Member
Joined
May 23, 2011
Messages
2
Hello everyone!

I've just started working with VBA on excel (the hard way, bumping my head on the screen sometimes :P), and I'd like to ask you guys something.

My project consists of basically 3 sheets:

- One that determines what kind of sheet the macro is going to show (with option buttons.

- A second that is determined by the first one (there are several sheets and the first macro chooses one for you to enter the data)

- A third one, this one gets the information of the chosen sheet and organizes and calculates.

This project is totally based on sheets and VBA macros assigned to buttons.

Now to the doubt: There are a number of products in the second sheet that could be changed, eg: 5 products with the quantities, prices and margins, and maybe I would like to add one more kind of product to the sheet so people are able to add it and type in the information.
This also has to apply to the 3rd sheet, so it shows the correct name and information about the new product.

Ok, I have NO clue on a method do make this an easy task for anyone who needs to do it. Any ideas?

Thx in advance!:pray:
Cya.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Hi kikz,

You didn't mention what type of list you are referring to. Is it a Data > Validation > List, or a Forms or ActiveX list control such as a combobox dropdown or listbox?

Damon
 
Upvote 0
I'm not using Forms or ActiveX right now.

It's a simple list like:

Product Quantity Margin
Gasoline--100------10
Ethanol---150------20
Diesel ----200------30

Changing the numbers or names of the already existing rows is easy, my problem is to add a new row and still make it work with the macros that are already made.

Hope it's clearer now.

thx
 
Upvote 0
Hi again kikz,

I understand now, but without seeing the code I have no way to know what changes to the macro are required so that it will still work when new products are added.

I'm going to PM you with my email address in case you'd like to send me your workbook so I can see all the context.

Damon
 
Upvote 0

Forum statistics

Threads
1,224,586
Messages
6,179,722
Members
452,939
Latest member
WCrawford

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top