VBA msgbox

%3CLINGO-SUB%20id%3D%22lingo-sub-1938051%22%20slang%3D%22en-US%22%3EVBA%20msgbox%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938051%22%20slang%3D%22en-US%22%3EHii%3CBR%20%2F%3E%3CBR%20%2F%3EI%20need%20a%20help%20in%20excel%2C%20could%20you%20please%20help%20me%20in%20this%3CBR%20%2F%3E%3CBR%20%2F%3EActually%20I%20need%20a%20data%20(previously%20added%20in%20the%20same%20worksheet)%20to%20be%20shown%20in%20dialogue%20box%20or%20like%20msgbox%20when%20I%20add%20data%20to%20the%20same%20worksheet%3CBR%20%2F%3E%3CBR%20%2F%3EThat%20means%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20data%20of%20products%20receiving%20from%20JANUARY%20TO%20DECEMBER%3CBR%20%2F%3E%3CBR%20%2F%3EAnd%20data%20is%20added%20daywise%20as%20received%3CBR%20%2F%3E%3CBR%20%2F%3EAnd%20I%20need%20suggestions%20on%3CBR%20%2F%3ECan%20excel%20shows%20the%20data%20of%20cell%20value%2C%20using%20other%20than%20filter%3CBR%20%2F%3E%3CBR%20%2F%3ESample%20data%20format%3CBR%20%2F%3E%3CBR%20%2F%3EDate.%3CBR%20%2F%3EGR%20no.%3CBR%20%2F%3EVendor%3CBR%20%2F%3EItem%20code%3CBR%20%2F%3EProduct%3CBR%20%2F%3EQuantity%3CBR%20%2F%3EReceived%20By%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20I%20add%20a%20new%20row%3CBR%20%2F%3EThen%20the%20previously%20added%20same%20product%20cell%20details%20to%20be%20shown%20in%20a%20msgbox%20or%20dialogue%20box%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1938051%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938069%22%20slang%3D%22de-DE%22%3ESubject%3A%20VBA%20msgbox%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938069%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F884439%22%20target%3D%22_blank%22%3E%40Muneer3313%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20an%20MS%20Excel%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EThere%20is%20no%20reason%20for%20the%20helper%20to%20want%20to%20reconstruct%20everything%20himself%2C%20what%20you%20basically%20already%20have.%3C%2FP%3E%3CP%3E*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor
Hii

I need a help in excel, could you please help me in this

Actually I need a data (previously added in the same worksheet) to be shown in dialogue box or like msgbox when I add data to the same worksheet

That means

I have a data of products receiving from JANUARY TO DECEMBER

And data is added daywise as received

And I need suggestions on
Can excel shows the data of cell value, using other than filter

Sample data format

Date.
GR no.
Vendor
Item code
Product
Quantity
Received By


If I add a new row
Then the previously added same product cell details to be shown in a msgbox or dialogue box
1 Reply

@Muneer3313 

With your permission, if I can recommend you, add a MS Excel file (without sensitive data) to your project.

There is no reason for the helper to want to reconstruct everything himself, what you basically already have.

* Knowing the Excel version and operating system would also be an advantage.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)