Macro button

%3CLINGO-SUB%20id%3D%22lingo-sub-2657527%22%20slang%3D%22en-US%22%3EMacro%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2657527%22%20slang%3D%22en-US%22%3E%3CP%3ECiao%2C%20sto%20cercando%20aiuto%2C%20ho%20bisogno%20di%20creare%20due%20pulsanti%3B%20uno%20che%20quando%20ho%20premuto%20viene%20visualizzato%20nella%20cella%20G2%201%20e%20ogni%20volta%20che%20l'ho%20premuto%20il%20numero%20da%201%20diventa%202%20poi%203%20ecc....%20L'altro%20pulsante%20ho%20bisogno%20di%20reimpostare%20i%20numeri%20della%20cella%20G2.%20Spero%20di%20essere%20stato%20chiaro%2C%20grazie%20in%20anticipo.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2657527%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2657599%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2657599%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1130643%22%20target%3D%22_blank%22%3E%40piaser549%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Ftech-community-discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ETech%26nbsp%3BCommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2657765%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2657765%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1130643%22%20target%3D%22_blank%22%3E%40piaser549%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuesto%20messaggio%20%C3%A8%20tradotto%20automaticamente%2C%20l'utente%20non%20pu%C3%B2%20parlare%20questa%20lingua%20(o%20molto%20poco).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENon%20hai%20bisogno%20di%20due%20pulsanti%20e%20codice%20vba%2C%20%C3%A8%20facile%20usare%20un%20pulsante%20di%20selezione.%20Conta%20verso%20l'alto%20come%20desideri%20(regolabile%20in%20base%20alle%20tue%20esigenze)%20e%20conta%20di%20nuovo%20verso%20il%20basso%20...%20il%20conteggio%20avanti%20e%20indietro%20diventa%20facile.%20Ecco%20un%20esempio%20con%20un%20pulsante%20di%20selezione.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESpero%20che%20questo%20ti%20abbia%20aiutato.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Se%20questo%20messaggio%20ti%20%C3%A8%20stato%20d'aiuto%2C%20contrassegnalo%20come%20risposta%20corretta%20e%2Fo%20con%20un%20Mi%20piace%2C%20in%20modo%20che%20anche%20gli%20altri%20possano%20trarre%20vantaggio%20da%20qui.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2659045%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2659045%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3B%26nbsp%3BHello%2C%20I%20really%20appreciate%20the%20speed%20with%20here%20you%20answered%20me%20and%20I%20thank%20you%2C%20only%20that%20that%20button%20for%20what%20I%20need%20I%20do%20not%20need%2C%20attached%20I%20send%20you%20an%20image%20of%20what%20I%20need.%20Thanks%20for%20your%20help.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Botton.png%22%20style%3D%22width%3A%20256px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303949iEDBE44BDAA92B0B8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Botton.png%22%20alt%3D%22Botton.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Ciao, sto cercando aiuto, ho bisogno di creare due pulsanti; uno che quando ho premuto viene visualizzato nella cella G2 1 e ogni volta che l'ho premuto il numero da 1 diventa 2 poi 3 ecc.... L'altro pulsante ho bisogno di reimpostare i numeri della cella G2. Spero di essere stato chiaro, grazie in anticipo.

7 Replies

@piaser549 

Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

@piaser549 

Questo messaggio è tradotto automaticamente, l'utente non può parlare questa lingua (o molto poco).

 

Non hai bisogno di due pulsanti e codice vba, è facile usare un pulsante di selezione. Conta verso l'alto come desideri (regolabile in base alle tue esigenze) e conta di nuovo verso il basso ... il conteggio avanti e indietro diventa facile. Ecco un esempio con un pulsante di selezione.

 

Spero che questo ti abbia aiutato.

 

Nikolino

 

* Se questo messaggio ti è stato d'aiuto, contrassegnalo come risposta corretta e/o con un Mi piace, in modo che anche gli altri possano trarre vantaggio da qui.

 

@NikolinoDE  Hello, I really appreciate the speed with here you answered me and I thank you, only that that button for what I need I do not need, attached I send you an image of what I need. Thanks for your help.Botton.png

@piaser549 

Here is how you can program a roulette game yourself.

https://www.youtube.com/watch?v=wt-rLdSZV2E&t=18s

 

Thank you for your patience and time.

 

Nikolino

I know I don't know anything (Socrates)

Mit ein paar Zusatzfunktionen und VBA lässt sich mit Excel auch zeigen, wie Roulette funktioniert.
Hi, thanks for your answer, I have watched the video but I find it too difficult for me and then it is in the language that I do not know.
Could you just tell me how to add a number and how to reset. Thanks in advance.

@piaser549 

 

Il codice VBA non è pronto, non ho sofferto il tempo necessario.

Ma puoi rivederlo tu stesso, il codice è molto semplice e autoesplicativo.

Adesso è tempo di andare in vacanza, vi auguro una buona estate.

 

Come selezionare le celle o gli intervalli tramite le procedure di Visual Basic in Excel

 

Hello, I wish you happy holidays.