Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

VBA in Excel

mregnolac

Recruit
Basic Member
Messages
9
Reaction score
0
Points
16
Help Guys:
Nais kung makuha ang each value of cell sa sample range("P19:P357") may condition kasi ako sa each cell, pagnakuha ko na ang value madali ko nalang ipasok ang condition.

I am using VBA in excel.

Thank you, comment lang sa may alam😁😁😁:help:
 
Help Guys:
Nais kung makuha ang each value of cell sa sample range("P19:P357") may condition kasi ako sa each cell, pagnakuha ko na ang value madali ko nalang ipasok ang condition.

I am using VBA in excel.

Thank you, comment lang sa may alam������:help:

Code:
Dim i as Integer
Dim ws as Worksheet

Set ws = Thisworkbook.Worksheets("YOURSHEETNAME")

For i = 19 to 357

Msgbox ws.Range("P" & i).value
'Insert your condition here


Next

Set ws = nothing
 
Thank you a lot it gives me an idea...

Thank you:yipee::yipee:
 
hi! pa tulong naman po kung paano ko ma view ung textbox ko sa ibang sheet using labelbox


Private Sub Label1_Change()
If Me.Label1.Value < 0 Then
Me.TextBox_NAME.Visible = True
Else
Me.TextBox_NAME.Visible = False
End If
End Sub


tnx..:)
 
Back
Top Bottom