Excel VB, Inventory Manager

[mwanyu]

Hello Members,

Thanks for being here and hopefully it will be my playground,
I have come across a tutorial in Youtube for Inventory Manager. Front End Excel and backend VB.
Just the time I attacked VB, An Error messege popped out on Running macro.

The error is as follows:

Run-time error '-2147024809 (80070057)':
The item with the specified name wasn't found.

Attached are few of the images (Excel 2013 App)

 

[GWteB]

The item with the specified name wasn't found.

I'm not sure but it looks like you don't have a Shape on your worksheet named "MoveBtn"

 

[mwanyu]

I'm not sure but it looks like you don't have a Shape on your worksheet named "MoveBtn"

I cant Afford a Smile.

Thanks a lot, I made it to the next step. Be Blessed.

Inventory_Manager.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	Trans. Type	Sales		INVENTORY MANAGER
2	Selected Trans.Row
3	New Trans	TRUE
4	Trans Load	TRUE				SALES TRANSACTION
5				Customer			Transaction Date
6	Product Row
7	New Product	TRUE		Product #			Sales Price:		Qty On Hand	5
8	Product Load	FALSE
9				Product Name			Type:
10
11				Std.Purch.Qty			Prod.Description
12
13				S/ales Qty			Total:		Notes
14
15
16	Hide Row ->
17				Trans. Type	Vendor/Customer	Trans. Date	Product #	Price	Qty	Total	Notes
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
Sheet1

Cell Formulas
Range	Formula
F4	F4	=IF(B1="purchase","PURCHASE TRANSACTION","SALES TRANSACTION")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D18:K49	Expression	=MOD(ROW(),2)=0	text	NO

 

[GWteB]

You're welcome and thanks for the feedback.