Excel 2013; User form to add data into looked up cells

KrVa46

New Member
Joined
Nov 10, 2016
Messages
1
Hello,

Unfortunately I'm no big VBE hero and I don't have a basis code to start from, but this is my question.

I created an excel document where I enter my expenses. All kinds of calculations happen and conditional formatting to get a quick view of budgets, results, expenses, ... It works fine and I'm happy with it.
Simplified layout in short:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Budget[/TD]
[TD]Budget left[/TD]
[TD]Overview expenses[/TD]
[TD]January[/TD]
[TD]Februari[/TD]
[TD]March[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Income[/TD]
[TD]+3000[/TD]
[TD]etc etc[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Rent[/TD]
[TD]-700[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]column A - column D[/TD]
[TD]Shopping[/TD]
[TD]-50-100-40-...
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Grosseries[/TD]
[TD]-15.5-7.2-54.8-...
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Kids[/TD]
[TD]etc etc[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
In the comments of the cell I keep track of the date and where specifically I spent the money.

Now my dad is starting to use it too, but since he is way more inexperienced he keeps doing stuff wrong so that results aren't correct anymore. Even with locking cells he still manages to break it ... :)


I was thinking of creating a user form where you can only fill in the necessary information and it adds it for you to the correct cell. Something like:
Amount: "text field to add the $"
Month: "dropdown list with the months"
Detail: "dropdown list with the various categories)
Comment "text field to add the comment that needs to be added"

--

So I need a userform that:
- looks up a cell based on the input in the user form (month and category)
- adds the amount entered in the user form to the cell (not replacing previous data)
- adds the comment of the user form to the comment of the cell

I can troubleshoot existing forms and make them work for me, but I need a basis to start from and unfortunately I don't find anything like this already created.

Can someone help me with this?
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

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