how to make a welding joint like this with macro

how to make this joint then be able to change its parameters thru a user form...i've tried different ways but it never worked with macros unlike using weld design...