Προς το περιεχόμενο

apo UserForm se excel ksereis ?


oldnew

Προτεινόμενες αναρτήσεις

Δημοσ.

Thelo na doylepso se excel me User forms ala den ksero pos ginetai,

mhpos mporei na vohthisei kaneis?

Tha prospathiso parakato na perigrapso th vasikh idea ti thelo na kano

esto 2 fila: filo1 kai filo2

to filo1 exei th morfh:

A..............B.............C...............

pelaths.......poso........kodikos

kostas........5000..........52

petros........6000..........35

. . .

. . .

 

kai to filo2

 

kodikos..........poso

52..............10000

70..............60000

 

 

klp

 

Thelo na emfanizetai ena Userform molis patao ena koympi, poy na diavazei

apo to filo 2 p.x kodikos 52 poso 10000 kai na grafei afta ta stoixeia pano toy,

na pigenei sto filo1 , na vriskei th gramh poy einai o singekrimenos kodikos,

kai na me rotaei an thelo na alakso to poso p.x ston kodiko 52 sto filo1 grafei

poso 5000, eno se afton ton kodiko sto filo 2 grafei 10000 . Na me rotaei

Thelete alagh toy posoy? kai an patao sto koympi nai, na alazei to poso sto filo1

apo 5000 poy htan se 10000.

 

Meta to synexizo monos moy gia ta ypoloipa posa.

Ksero kapia pragmata apo visual basic se excel, me koympia, ala den ksero apo

user forms, apo oti katalava afto pou thelo prepei na ginete me user forms.

Pos mporo na emfaniso 1 user form? ante kai to sxediazo, meta ti ginetai?

Ta koumpia ta vazo se ena filo, sthn epifania toy, kai meta pao kai grafo sto

antistoixo prive sub, ton kodika, edo ti ginete?

an kserei kaneis , please help.

Δημοσ.

mpoereis na to kaneis poli apla me koumpakia tis vb mesa stin access. ...

oute kwdika oute tipota periploko....

apla bazeis ena koumpaki panw sto keli p.x. a1, sto opoio prepei na oriseis 2 epiloges... a) poio keli tha elegxei, kai B) apo pou tha pernei tis times...

twra auto einai to aplo kommati ...

as poume oti theleis na emfanizetai i timi tou eidous pou exeis epilexei sto keli b1, (akribws dipla) edw prepei na grapseis sinarthsi xrhsimopoiwntas tin entoli index.... den thimamai tin syntaxh ths akribws, alla an tin brw tha sou tin steilw....

 

elpizw na boithisa....

:D

Αρχειοθετημένο

Αυτό το θέμα έχει αρχειοθετηθεί και είναι κλειστό για περαιτέρω απαντήσεις.

  • Δημιουργία νέου...