1

Hi guys i'm try learn VBA Excel , i have a problem in my project

See this picture

i'm try to make a insert statement , when i'm insert "1" then the result is "book 1", but to show the result i need click some command button, so how can i do to make it automatic to show the result without click button

This is before i click the command button this is the before i click the command button

This is after i click the command button this is after i click the command button

thanks guys , sory for my bad english :D

JvdV
  • 70,606
  • 8
  • 39
  • 70
Riky Andreas
  • 220
  • 3
  • 13
  • 3
    Please [edit] your question with your code as text, not as a screenshot, thanks. – BigBen Feb 03 '20 at 18:35
  • 3
    Also, take a look at the [`Worksheet.Change`](https://learn.microsoft.com/en-us/office/vba/api/excel.worksheet.change) event for this to happen automatically. – BigBen Feb 03 '20 at 18:35
  • 2
    agree with @BigBen. `Worksheet_Change` can handle that for you.. You may also want to see [THIS](https://stackoverflow.com/questions/13860894/why-ms-excel-crashes-and-closes-during-worksheet-change-sub-procedure/13861640#13861640) – Siddharth Rout Feb 03 '20 at 18:38

0 Answers0