S
Shane
I have a workbook "Case Prep File" that holds this macro. Before running, I
open a second workbook "Client List". I am trying to run (using a
commandbutton) a macro that takes information from "Client List" and feeds it
into a Userform. The information that I enter into the Input Box should
match one (or more) numbers in "Client List", Column A.
As I test this macro (while stepping through it) I see that GIDInput value
is the number I enter, but TMIS.Range("groupid").value is the same number
with quotations around it. I thought that using "@" in the code will make
them of the format, but I think that isn't working correctly.
Help, please! (It runs through the whole list without ever entering the IF
statement, so I don't even know if that code works right either, so if you
see issues there, please help me out there too)
open a second workbook "Client List". I am trying to run (using a
commandbutton) a macro that takes information from "Client List" and feeds it
into a Userform. The information that I enter into the Input Box should
match one (or more) numbers in "Client List", Column A.
As I test this macro (while stepping through it) I see that GIDInput value
is the number I enter, but TMIS.Range("groupid").value is the same number
with quotations around it. I thought that using "@" in the code will make
them of the format, but I think that isn't working correctly.
Help, please! (It runs through the whole list without ever entering the IF
statement, so I don't even know if that code works right either, so if you
see issues there, please help me out there too)