Microsoft Excel HELP

[UK][Arian] · 05-04-04, 15:36

salam azizan e GOL,, haye ke ba microsoft Excel,, baladan,, kar konan,,
vala ma ke macro darim minevisim,, mesle Submit button manandeh mimone,, man befarze mesal,, 3 ta sheet daram,, 2 ta sheet ba info, avali ham main sheet,, to sheet e avali ye Cell daram ba ye submit button,, man mikham ye kari konam KE,, age yeki to ye on cell,, masalan type kone "30" va submit o bezane bere to sheet e dovom,, manzor AGAR,, shomare ke user mizane,, az "0" ta migim "50" bod, bere to sheet e aval,, agar az "50" be bala bod bere sheet e dovom,, vaghti ke submit o mizanan,, khoda kone yeki befahme chi migam lool

alaki ba khodemon harf nazanim hehe,,
any way, man khodam ye code neveshtam,, midonamam kar mikone,, valii kar nemikone hehe ye kam chiz kamo kasr dare,, any way code o inja minevisam,, agar ke shoma rahe dige e ya chizi baladid,, lotfan,, khailii khailii mamnon misham inja base man replie konid o begid..

azizan,, sorry in ye tike sansor shod,, codesh khaili ye kam deraze,,

nashod type konam,, vali az tarighe Select Case in karo kardam,, any way khaili mamnon misham age,, yeki ye komaki bokone,,

**[OP]Nima** · 05-04-04, 15:41

khob azize man.. miomadi azam miporsidi behet begam.. kari nadare.. bia msn alan behet begam

)

[UK][Arian] · 05-04-04, 16:01

bah bahh,, nima ma masalan aval az khodet soal kardim,, che jori kar mikone,, bebin chi goft torokhoda,,

**darvish** · 05-04-04, 16:03

Arian jan shoma plugine visual basic o add kon roooye excell bayek if statement e kheili sadeh (just couple of lines) mitooni macro ro dorost koni.

[UK][Arian] · 05-04-04, 16:15

hamichi o daram..

mitonam edit konam,, hame chi radife dada nader,, vali balad nistam tamom konam, code o.

**darvish** · 05-04-04, 16:20

valla Arian jan man omrie dige ba basic kari nadaram, az windows omrie ke dooram, vali inke ye macro benevisi ke roosh click koni value e ye cell o begire o ba ye if statement check koni az yechizi bozorgtare ya koochiktare bad bere folan sheet o active kone kare ziad sakhti nabayad bashe, if (sheetNO!cellNO > 50 ) command, manzooram ine ke algorithm o dashte bashi halle, hala agar VB balad nisti oon ye harfe dige, 1 saat vaght bezari MSDN o bekhooni rooye microsoft.com hast besoorate majjani be rahati mitooni rah bendazi kareto, badesham vase active kardane page ye record macro begir, command hasho too code dar biar, bendaz too VB script o safa kon.

har moshkeli ba khoondan hal mishe, read read read and read.

[UK][Arian] · 05-04-04, 16:56

mamnon nader jonnnnnnn :*~ man che ghad az in nader khoshemon omadeh khodaie

agha ye chizi,, alan ye code haminjori neveshtam binam mishe,,
ino neveshtam

Code:

If Sheets("a") And Range("a2") > 50 Then
  
  Sheets("b").Select
  Range("a3").Select

Else

Sheets("c").Select
Range("a2").Select


End If
End Sub

Vali goft ke,, khaste IF e avalesh ye kam eshtebah dare,, nader any idea's?

Quote:

If Sheets("a") And Range("a2") > 50 Then

mige in ghalate

**darvish** · 05-04-04, 17:11

fekr konam bayad combine koni sheet o ba cell masalan if (Sheet1.A11) > 50, motmaen nistam migam 5-6 sal mishe kari ba in chiza nadashtam, vali fekr konam bayad yejoori combine koni, behtarin rahesh ine ke az record macro estefade koni bebini chejoori code o handle mikone.

[UK][Arian] · 05-04-04, 17:31

ok aziz mamnon baz :* tashakor

**[OP]Nima** · 05-04-04, 18:00

khob manam ino az aval behet goftam arian jan.. mage gosh dadi... :P