VBA Referring to a Cells/Columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1430836%22%20slang%3D%22en-US%22%3EVBA%20Referring%20to%20a%20Cells%2FColumns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1430836%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20Is%20there%20a%20way%20to%20refer%20a%20text%20box%20on%20a%20User%20form%204%20on%20sheet%203%20to%20a%20columns%20on%20sheet%201.%20such%20that%2C%20I%20have%20a%20table%20heading%20on%20Sheet%203%20thus%3A%20(S%2FN%2C%20Name%2C%20Amount%2C%20Loan%2C%20etc)%2C%20also%20on%20sheet%201%20there's%20a%20table%20header%20namely%3A%20(S%2FN%2C%20Name%2C%20.........%2C%20Total%20Balance%2C%20Other%20Services).%20So%20that%20the%20total%20transaction%20(i.e.%20Amount%20%2B%20Loan)%20made%20on%20sheet%203%20generate%20with%20user%20form%204%2C%20to%20be%20added%20to%20sheet%201%20column%20(Total%20Balance)%20.%20Looking%20forward%20for%20a%20quick%20response.%20Thank%20you%20so%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1430836%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hello! Is there a way to refer a text box on a User form 4 on sheet 3 to a columns on sheet 1. such that, I have a table heading on Sheet 3 thus: (S/N, Name, Amount, Loan, etc), also on sheet 1 there's a table header namely: (S/N, Name, ........., Total Balance, Other Services). So that the total transaction (i.e. Amount + Loan) made on sheet 3 generate with user form 4, to be added to sheet 1 column (Total Balance) . Looking forward for a quick response. Thank you so much.

0 Replies