Joining Two Macros - Microsoft Office Excel - Страница 2

london735 · 29.06.2008, 13:35

can anyone please explain to me how to view the actual macro code in the last file SAS888 attached?
thanks!

IgorGO · 29.06.2008, 15:00

click "code" button in top left corner

SAS888 · 29.06.2008, 16:47

1) See answer from IgorGO
2) Right click on a form in VBE, then press "View code".
3) Double click on a form in VBE.

This code will be run on event "Activate", that is started from makro "Start" (after performing the command "UserForm1.Show" of macro).

london735 · 29.06.2008, 18:37

cool! thanks...i now can see the code....thanks again for taking the time to do this for me!

29.06.2008, 16:47	#13
SAS888 Старожил Регистрация: 05.12.2007 Сообщений: 4,180	1) See answer from IgorGO 2) Right click on a form in VBE, then press "View code". 3) Double click on a form in VBE. This code will be run on event "Activate", that is started from makro "Start" (after performing the command "UserForm1.Show" of macro). Чем шире угол зрения, тем он тупее.

29.06.2008, 13:35	#11
london735 Пользователь Регистрация: 20.06.2008 Сообщений: 45	can anyone please explain to me how to view the actual macro code in the last file SAS888 attached? thanks!

29.06.2008, 18:37	#14
london735 Пользователь Регистрация: 20.06.2008 Сообщений: 45	cool! thanks...i now can see the code....thanks again for taking the time to do this for me!