Hi Suresh,
Remove the 8th line from your macro .i.e. "Next". It's not required.
Here is modified code which is shorter and more readable than before.
Tip: Always indent your program, it increase readability and hence
error evaluations.
Private Sub ok_Click()
Dim a As Integer
a = Val(tex
Hi All,
Can anyone check whether below codes are correct or not.
I am getting error message while i run this code.
Private Sub ok_Click()
Dim a As Integer
a = Val(text1.Text)
If a = bp Then
Application.ActiveSheet.Unprotect
ActiveWorkbook.Unprotect
UserForm1.Hide
Next
End If
If a > 2 Then
'
Hi Maddy,
Your query is quite simple and I wonder if you know VBA, Vlookup and
every other thing then where did you stucked up?
Since you've provided detailed info in algorithmic format, I've tried
to solve your query. If this doesn't suffice you then you need to
carefully look into your logic pr
Thanks Dave
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel t
Harmeet,
I am able to do sort & do a lookup and I can also write VBA code for
the sort & lookup functions. However, my problem is the macro should
sort the names in Valuation tab as per their order in PV tab,
irrespective of their current location.
Request you to go through my spreadsheet (espec
I request everyone who tries to answer my request, to go through my
attached spreadsheet especially For Your Information Tab COMPLETELY
and CAREFULLY.
YET NOW NO ONE HAS PROVIDED ME CORRECT SOLUTION. I am wondering
whether anyone correctly understand my issue or not. :(
On Mar 23, 12:18 pm, Dili
