Posts by lakshi

I think what you have suggested would fulfill my requirement. Could you please share the code (or the method) to do it.

Many thanks!

Order Request won't be deleted once the order is accepted.

Below is my requirement. Please check it and assist. Highly appreciate your support.

There are 2 sheets and 1 user form:

1st sheet: Stationary Inventory

2nd sheet: Order Request

User Form: Order Request user form

When an entry is made and saved in the user form it is recorded in Order Request sheet.

As an example: in a order request, there is 20 pens is recorded. When the request is saved using save command button, another command button (CommandButtonIssue) should be created in the same row of the order request was recorded in Order Request sheet. When CommandButtonIssue is clicked, 20 pens should be deducted from pens inventory which is recorded in Stationary Inventory sheet.

This is the part of a module which is for stationary management in a office.

Through this staff can request stationary via order request. Stationary admin can issue stationary as per the request (via CommandButtonIssue). When Stationary is issued, inventory is auto updated.

Many Thanks for assisting!

Sorry for missing code tags. I tried to find it but couldn't. Going forward will do.

If hyperlink cannot do it, is it possible to auto create a command button instead of the hyperlink. Then via that command button to update the cell value in other sheet?? If there is code for that kindly share.

Many Thanks!

Hi All,

Much appreciate, if anyone could help me to auto create a command button when click another command button in a specific cell and assign code to the newly created command button.

I have very less knowledge on excel VBA. The first command button (let's say Command1) is on a user form. When Command1 is clicked a new command button (Command2) should be created on a specific cell in a worksheet (Sheet1). When Command1 is clicked macro should be auto assigned to Command2.

Please help me to get this done.

Much thanks!

Hi all,

Could you please help me to include a command to a hyperlink. I want to update a cell value in another sheet when hyperlink is clicked. I have the code for hyperlink directing to website (mentioned below). Is there a way to modify this code so that when hyperlink is clicked, a cell value in another sheet is updated.

Code I have:

ActiveSheet.Hyperlinks.Add Range("E2"), Address:="https://www.automateexcel.com/", TextToDisplay:="Issue", ScreenTip:="Issue Stationary to Request Owner"

Could you please explain if there is a method to include a command instead of the orange colour part below, so that the command will deduct the stock from other sheet when hyperlink is clicked (same as it directs to the website, when website URL is there). Kindly explain if it is possible.

Highly appreciate your support.

Code:

ActiveSheet.Hyperlinks.Add Range("E2"), Address:="https://www.automateexcel.com/", TextToDisplay:="Issue", ScreenTip:="Issue Stationary to Request Owner"

Thank you very much for the shared module.

Could you please advise is it possible to use VBA sheets and sheets that uses formula in a single workbook.

That website code is just for testing purpose.

Supposed hyperlink is the easier way. What i want is an hyperlink should be auto generated when the new entry is created in Request Record (via userform). afterwards, when hyperlink is clicked the inventory sheet should be updated.

If this is not the right method, please explain how to use an event code for this.

Thanks!

Hyperlink is in the "Request Record" sheet. When clicked on hyperlink i want to deduct the the quantity of the item mentioned in the row where hyperlink is located, from the quantity of same item mentioned in "Inventory" sheet.

Thanks!

Please find the workbook attached herewith. Thanks!

Hi Roy,

Thank you for your quick reply. If the second image of above post is not clear please refer below image. Thanks!

In below, highlighted in yellow are the hyperlinks i created using vba codes.

When hyperlink is clicked, i want to deduct the item qty in another sheet (which is stationary inventory sheet). Below mentioned is the screenshot of stationary inventory sheet. Above is the Order Request sheet. Hope this is more clear. Much thanks!

Hi All,

I am a whole new person to excel VBA. I am developing a simple stationary management module and i want to deduct a cell value, when clicking on the hyperlink which is in a different sheet where the cell is located.

Thanks a lot in advance to solve this for me!