• Úvod
• Excel návod
• Excel šablony
• Nástěnka
• Mobility
• Tipy na výlet
• Galerie
• Fórum

MS Excel

Téma: MAKRA v EXCELI

Zaslal/a Koeman 30.8.2016 10:27

Dobry den,
mam n.u. makra v exceli, v zasade s nimi nemam ziadne skusenosti, ale potreboval by som editovat moznosti pri jedn. bunkach, teraz je tam napr. moznost vykliknutia poctu napr. 1 alebo 2, ja by som chcel 1,2,3,4..nastavuje sa to cez makra?

dakujem za akulkolvek radu

Sub check_box29()
Dim a As Range

Set a = ActiveCell
ActiveSheet.Shapes("Check Box 31").Select
With Selection
.Value = xlOff
End With
ActiveSheet.Shapes("Check Box 34").Select
With Selection
.Value = xlOff
End With
a.Select
End Sub
Sub check_box31()
Dim b As Range

Set b = ActiveCell
ActiveSheet.Shapes("Check Box 29").Select
With Selection
.Value = xlOff
End With
ActiveSheet.Shapes("Check Box 34").Select
With Selection
.Value = xlOff
End With
b.Select
End Sub
Sub check_box34()
Dim c As Range

Set c = ActiveCell
ActiveSheet.Shapes("Check Box 29").Select
With Selection
.Value = xlOff
End With
ActiveSheet.Shapes("Check Box 31").Select
With Selection
.Value = xlOff
End With
c.Select
End Sub
Sub check_box41()
Dim d As Range

Set d = ActiveCell
ActiveSheet.Shapes("Check Box 42").Select
With Selection
.Value = xlOff
End With
d.Select
End Sub
Sub check_box42()
Dim e As Range

Set e = ActiveCell
ActiveSheet.Shapes("Check Box 41").Select
With Selection
.Value = xlOff
End With
e.Select
End Sub

Zaslat odpověď >

---

Pavlus(30.8.2016 11:19)#032492

Z tohoto těžko posoudit ;-).
Vlož sešit, ve kterém potřebuješ upravit...
P.citovat

Koeman(30.8.2016 14:33)#032498

dakujem za ochotul, uz sa mi to podarilo vyriesitcitovat

Uživatelské menu

Nejste přihlášen(a)

• přihlásit
• registrace

\n

Menu

On-line nástroje

Formulář Faktura

Aktivní diskuse