• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search item code no from item master dataset

Hello Narayan Sir,

Have you make some necessary changes for calling quantity.

This is kindly remind you.

Warm Regards,

Zameer
 
Hi Zameer ,

I am not able to understand your exact requirement.

I have defined a named range called List , referring to =IssueRegister[Nomenclature]

Have you redefined this to refer to any other range in the worksheet ? If so , what is the definition ?

All the labels are being updated with values , which are referenced in relation to the named range List ; if you have redefined List , all that has to be done is to update the labels with values which have the desired relation to List.

Let me know which label should contain data from which column on which tab ?

Narayan
 
Hello Sir,

As your define the name range List from IssueRegister[Nomenclature], And i need the Range List from the Sheet ItemMasterRegister [Nomenclature]. I have redefine the name range List IssueRegister to ItemMasterRegister. Its works perfectly. But the Data of the Label of Quantity is referring the colomn K of the Sheet ItemMasterRegister. And i want the Quantity return from the Colomn N in the same sheet [Closing Balance].

Thant the only changes i need. Sorry if i tolerate you. This happend only for language problem Sir.

For your Kind information please.

Warn Regards,


Zameer
 
Hi Zameer ,

In that case replace the existing statement by the following :

Label7.Caption = Format(Application.WorksheetFunction.Index(code_range.Resize(, 7), Match_Row, 7), "##,##0.00 ")

Narayan
 
Hello Narayan Sir,

Hooreyyyyy:DD

Its Works Perfectly. Once Again Big Thanks from Big Hear:confused:

Thanks for giving you precious time for me Sir, God Bless you...

Warm Regards,


Zameer Shaikh
 
Hello Sir,

After all solve the problem, there is workbook giving problem after 10 to 15 minuts massage displayes. " Excel Stop Working", when i click the problem displayed its show.

Problem signature:
Problem Event Name: APPCRASH
Application Name: EXCEL.EXE
Application Version: 12.0.4518.1014
Application Timestamp: 45428263
Fault Module Name: VBE6.DLL
Fault Module Version: 6.5.10.20
Fault Module Timestamp: 45187577
Exception Code: c0000005
Exception Offset: 00111497
OS Version: 6.0.6002.2.2.0.256.6
Locale ID: 1033
Additional information about the problem:
LCID: 1033
Brand: Office12Crash
skulcid: 1081

What should i do? Please advise suitably.

Warm Regards,


Zameer Shaikh
 
Hi Zameer ,

I am sorry , but from the information given I have no idea what the problem can be.

However , I am not able to understand why you need the ClockOn and ClockOff and the Timer procedures ; please understand that unless a functionality adds value to the application or the user experience , you will do better to remove it.

Try removing this particular functionality and see if the problem persists.

Narayan
 
Hello Narayan Sir,

I need clock for the current time punch When the Gatepass Print. May you saw SIMS workbook. And can you suggest alternate for it. Becouse i need clock.

Warm Regards,

Zameer Shaikh
 
Hi Zameer ,

The current time is always available , even if you do not have these procedures. I am not aware of how your application is using the procedures.

Narayan
 
Dear Narayanan Sir,

Really nice to see your file.
Could you please explain me the login in which the file had been worked out.
I am not much aware of macros but I am interested to learn it to the core.
As I am in SAP field it will be helpful for me to use working with bulk data.

Sir my requirement is I need to search data both based on description as well as price based.

Vignesh.V
 
Last edited:
You must log in or register to reply here.
Back
Top