ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Two Quick Questions (https://www.excelbanter.com/excel-programming/316995-two-quick-questions.html)

Chuckles123[_66_]

Two Quick Questions
 

Tom,

My link in the main code was 'Range("PROCEEDS").Value = Cash';
changed this to 'Range("PROCEEDS").Value
CDbl(txtCASH_REQUIRED.Text)'. I then received an Error 424 messag
(Object Required). I then inserted
'Public txtCASH_REQUIRED As String' outside the procedure but in th
same module. I then received a Compile error message ("Invali
qualifier") on
txtCASH_REQUIRED in the second Range("PROCEEDS").Value stmt above.

Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=27890



All times are GMT +1. The time now is 08:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com